2

I have a MS Access database and I want to convert it to run on MS SQL Server.

How can I export it?

Improve this question
1
  • It's not clear if you have an Access application with Jet data tables and you want to upsize only the data tables to SQL Server or if you think that SQL Server upsizing will also convert your forms/reports/etc. to something else -- it will not. Commented Mar 18, 2009 at 0:39

4 Answers 4

Reset to default
4

You can also use SQL Server Integration Services to import into SQL Server (2005), rather than export.

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

Comments

2

Tools.. Options... Upsizing Wizard, if I recall correctly.

Strictly speaking, you'll always need software to do it, unless you have 3 wishes from the ETL fairy.

Improve this answer

Comments

0

If your SQL Server is SQL Server 2000 or SQL Server 7, SQL Server Integration Services mentioned by Miles D was calles Data Transformation Services. By the way: I love this tool. It's awesome.

If for some reason you can't (or don't want to) use any of these tools, you could always write a very short piece of code (in Java, C# or whatever you feel comfortable with) to accomplish the same thing for your specific problem.

Improve this answer

Comments

0

Use the free Microsoft SQL Migration Assistant for Access (SSMA): it's purpose is to convert Access apps to SQL: it's great and it's free.

I wrote a blog post about it:
http://blog.nkadesign.com/2009/ms-access-upsizing-to-sql-server-2008/

Improve this answer

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.