Migrating Access DB to MS SQL

[Guest]

I'm building and Access database that in the near future might outgrow
Access. Can Access DB be migrated to SQL without loosing the structure?

 

[Kevin3NF]

Not with the click of a button, but its generally not that hard to move the
tables to SQL Server. Moving queries can be more difficult, depending on
how complex your queries are...

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm

www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.

www.experts-exchange.com - experts compete for points to answer your
questions

 

[Guest]

I setup SQL DB and went through importing my tables form Access. It went
through except 7 tables that failed. The problem however is that I can't
find any of my table in the SQL DB. Do you have an idea where my tables went?

 

[Kevin3NF]

Whereever you chose for them to go in the Destination screen of the DTS
Wizard (assuming that's how you did it...)

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm

www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.

www.experts-exchange.com - experts compete for points to answer your
questions