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

[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

 

[Guest]

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

 

[holysmokes99]

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.

 

[Cor Ligthert [MVP]]

Hi,

This is new for Net 2.0 however that is SQL Express as well, See this sample
about factory

http://www.vb-tips.com/default.aspx?ID=8c3dc2d7-1232-4dd1-817e-22eaaebb2723

I hope this helps,

Cor