I have a MS Access database and I want to convert it to run on MS SQL Server.
How can I export it?
-
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.
-
You can also use SQL Server Integration Services to import into SQL Server (2005), rather than export.
-
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.
-
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/
0 comments:
Post a Comment
Note: Only a member of this blog may post a comment.