August 19, 2004 at 7:12 am
Hi!
I need solution for my problem.
the scenario is that We have an DB created in Access, it contains some data. Now we have updted our DB to SQL and certainly with changed structure, but we want to port data from the access db to sql db even though its structure is changed.
So anyone who can help!
August 19, 2004 at 7:19 am
Script the SQL Server database, Recreate it by upgrading Access database using Access upsizing wizard to move the Access database including data to SQL Server and reapply the changes from script.
Or
Use DTS to move the data.
August 19, 2004 at 8:26 am
use a dts package with field mapping
MVDBA
August 23, 2004 at 11:26 am
A third option is to open the Access DB and link to the appropriate SQL Server tables then use queries to move the data. This is especially useful if you want to check everything as you go or if you want immediate feedback one table at a time. However, it will only work if the data types are compatible between the tables. If you have made any major changes (a field was text in Access and is numeric in SQL Server) the query will fail.
Don
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply