I have a MS Access database and I want to convert it to run on MS SQL Server.
How can I export it?
+2
A:
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.
gbn
2009-03-17 05:35:35
+3
A:
You can also use SQL Server Integration Services to import into SQL Server (2005), rather than export.
Miles D
2009-03-17 09:06:00
A:
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.
Pablo Santa Cruz
2009-03-17 10:53:31
A:
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/
Renaud Bompuis
2009-03-25 14:09:10