Hi, what is the best way to go to migrate from access to MSSQL on a remote (hosted) server? do I have to create manually de tables and then move the data? or is there a way to create the creation scripts from the ACCESS database?
Thank you
DiegoI just use the Upsizing Wizard in Access. It does most of the work for you.
Tools->Database Utilities->Upsizing Wizard
You need to have a DSN that points to the SQL database built beforehand.|||there's also this:
http://www.microsoft.com/sql/solutions/migration/access/default.mspx
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment