471,356 Members | 1,645 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,356 software developers and data experts.

Data Migration using ADO.NET

I want to transfer large amounts of data from an access database to a SQL
server database. The schema within the Access database is vastly different to
the SQL Server one.
Mapping data from access to SQL server is relatively straight forward.
What I'm less sure about is the best approach to take to achieve this.
Best option I've come up with so far is to use a .NET windows app which uses
ADO.NET to read data from access into a typed dataset file using data
adapters. This data can then be modified according to the sql server schema
(eg non null columns all have values, correct relationships created etc.),
before being written out to the sql server database.
To ensure that the dataset does not become too big I was intending to read
one row (along with all its relating rows) at a time. Once this data has been
modified and outputted to the sql server database the data could be discarded
from the dataset to make way for the next row.
Anyone have any thoughts on this?

Jul 28 '05 #1
0 1029

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by pankaj_wolfhunter | last post: by
2 posts views Thread by contact1981 | last post: by
reply views Thread by XIAOLAOHU | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.