Access 2007 to SQL

Question

All,

I have an Access DB with 20 tables. I want to if i can make an automated process to convert all from Access to SQL in one shot rather than going one by one.

Thank You

Answer 1

Here is a good collection of info on upsizing Access databases to SQL Server:
http://www.granite.ab.ca/access/sqlserverupsizing.htm

Here is a link to download the SQL Server Migration Assistant for Access:
http://www.microsoft.com/downloads/details.aspx?FamilyId=133B59C2-C89C-4641-BEBB-6D04476EC1BA&displaylang=en

---

Plamen Ratchev

Answer 2

You can also try this product: http://www.sqlmaestro.com/products/mssql/datawizard/
The trial is compeltely useful. If you are going to do something with other DB engines you can select another product from the product list on the site.

---
Paul Svirin
StarWind Software developer ( http://www.starwindsoftware.com )