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

[Tom van Stiphout]

On 9 Feb 2006 15:10:56 -0800, "Ho**********@hotmail.com"
<ho**********@hotmail.com> wrote:

Can't a DTS (data transformation services) package in SQL Server do
that already?

-Tom.

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

[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?...e-22eaaebb2723

I hope this helps,

Cor