Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mart0369
Starting Member
11 Posts |
 Posted - 2008-11-11 : 09:31:27
|
Morning all,I need to combined 4 access applications to a new SQL/coldfusion application. Their data model is similar, but not quiet. The Access version (old) has everything in one table. The SQL (new) has been normalized. I need to migrate the access data to the SQL.I was thinking of writing a script in vb or coldfusion (what is on the server) to do so, or would a script in SQL be better? There is 4k+ records times 4 access databases.Any suggestions would be great! Cheers |
|
|
Raibeart
Starting Member
8 Posts |
Posted - 2008-11-12 : 11:20:40
|
| If you are using SQL 2005, use SSIS to do the migration. If you are in SQL 2000, use DTS. These tools are designed to do what you are wanting to do and they can hond the migration logic to keep all of the tables in SQL synced with the new normalized records. |
 |
|
|
steve-staten
Starting Member
1 Post |
Posted - 2008-11-12 : 11:46:08
|
| I used SSIS recently for the same thing. It was easy. The OLE Db connection to Access eliminated the need to identify field sizes and names. I just checked off which fields I wanted moved to the destination table. Each move was a module and I was able to daisy-chain the modules together. |
|
|
|
|
|
|
MS Access to SQL server migration question