By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,573 Members | 1,845 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,573 IT Pros & Developers. It's quick & easy.

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

P: n/a
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

Feb 9 '06 #1
Share this Question
Share on Google+
3 Replies


P: n/a
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
"Ho**********@hotmail.com" wrote:
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

Feb 10 '06 #2

P: n/a
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.

Feb 10 '06 #3

P: n/a
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?...e-22eaaebb2723

I hope this helps,

Cor
Feb 10 '06 #4

This discussion thread is closed

Replies have been disabled for this discussion.