Need to upgrade users from access db to SQL Server db through code...

  • Thread starter Thread starter 0to60
  • Start date Start date
0

0to60

I want to roll out an update that will update my users databases from Access
to SQL Server. Now, I have the scripts all written that will create all my
tables and relationships and such, but I need to copy the data over. What
is the recommended way to do this in code?
 
If you have the option, use DTS (SSIS in SQL Server). You can also export to
a CSV and use one of the SQL Server bulk loading methods. Or, you can create
a DataSet in code, populate from Access and update SQL Server with it. It is
a bit trickier this way, but uses a syntax you would understand if you have
done a lot of ADO.NET.

The longevity of the code is one of the keys. Is this a one time thing or do
you need this to be done from time to time? If this is perpetuaal code, I
would spend the time to set up DTS/SSIS if it were me. This can be expensive
(time wise) on a one shot deal.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

*************************************************
Think outside of the box!
*************************************************
 
Back
Top