1

I have produced a small program that uses a database created in MS Access. I have created about 5 queries for the database to test it and everything is working fine. I want to learn something new, so I decided to improve my program by migrating DB to SQL Server, but I don't really know where to start from. I have installed MS SQL Server 2012 and looking for some tutorials/pointers for beginners. My initial goals are:

  • Convert MS Access database to SQL Server

I believe that the up-size wizard included in MS Access can be sufficient for the job. Am I right?

  • Connect my C# program to DB saved on SQL Server

I think that I should edit my connection string and replace OleDb with something else... What should it be?

Improve this question
2
  • A question a bit too broad. Perhaps you should make three separate questions (and still you should try to do some research before) Commented Aug 6, 2013 at 18:23
  • I agree, I might be a bit broad. I will try to improve it. Thanks Commented Aug 6, 2013 at 18:24

1 Answer 1

Reset to default
1

I am not sure if the tool exists also for Sql Server 2012 but in 2008 R2 you have a menu entry in the Program Group for Sql Server called Data Import Export (32bit) (Translated from my localization, hope to be near at the exact thing) that could be used to port an MS Access Database to a SQL Server. Of course you need install Sql Server Management Studio to manage the fine details of your new database.

For the code part (connection string) you could continue to use OleDb changing only the connection string (see here at www.connectionstrings.com), but your best option is to change everything and use the classes in the namespace System.Data.SqlClient like SqlConnection instead of OleDbConnection, SqlCommand instead of OleDbCommand and so on....

Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.