VB.Net code to upsize Access DB to SQL Express?

  • Thread starter Thread starter Holysmokes99
  • Start date Start date
H

Holysmokes99

Hello, All

I would like to write a VB.Net app that will take an Access 2000
database that has tables, relationships, and data (no queries, forms
macros, etc), and create a corresponding SQL
Express database that matches it. The application will have no idea of
what's in the database ahead of time other than the fact that there are
tables with data and relationships. Any suggestions on how to proceed?
I suppose I need to iterate through the Access tables and
relationships, but I am not sure how this is done. Once I can do this,
I imagine that it is fairly straight forward to create the data objects
in SQL Express using ADO.Net.

Thanks for any suggestions,
Marcus
 
Marcus,

If you just need to get the Access database converted to SQL Server, the
Access upsizing wizard will do this for you.

Kerry Moorman
 
Thanks for your response, Ken. The thing is, this needs to be done
behind the scenes without any user input except for pointing to the mdb
file, and the location and username/password for the SQL Express
database. I wonder if the upsizing wizard can be embedded in my code,
or is exposed through COM. Hmmm...

M.
 
Back
Top