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 |
|
mfn24
Starting Member
1 Post |
 Posted - 2004-01-07 : 20:20:54
|
| Hi! Currently we have Access database. And I was tasked to migrate and redesign the schema in SQL 2000. Would you know of third party software that will make data migration less painful. The new design involves changing to appropriate datatypes (ie text - datetime) and rearranging some tables. Some columns have moved to new tables after normalization.I was thinking of doing this in 2 steps. First, importing Access db in SQL 2000 using DTS. Next is migrating the SQL db to a new db with the new schema. I'm looking at tools that will somehow help me out map the table-column from the old database to the new database. I can perhaps change the datatypes afterwards.Please help.rgds,mAAn |
|
|
smccreadie
Aged Yak Warrior
505 Posts |
Posted - 2004-01-07 : 22:00:30
|
| I think you will find that most people just use DTS to copy the data. You can run transformations in DTS which will change data types as well. I'm not aware of any special conversion tool for this - it takes work anytime the schema changes. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-01-08 : 12:54:06
|
| Why not use T-SQL for this? T-SQL can go across databases or servers.Tara |
|
|
|
|
|
|
Moving data to a new database...