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 |
|
gison
Starting Member
5 Posts |
 Posted - 2009-02-19 : 09:28:21
|
| Dears,This is the current situation I encountered.We are going to upgrade an small ERP system.1. Legacy System: old version Application base on SQL Server 20002. New System: new version Application base on SQL Server 20053. Two application has some differences on the table schema.=================================================================At the moment I'm surveying two solution:A. Writing a SQL script to migrate dataB. Writing a SSIS to migrate data=================================================================Do you guys have any suggestion on this kind of situation.Since I really don't have too much idea on that.Deeply thank you,gison |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-02-19 : 09:37:14
|
| isnt a backup from 2000 and restoring to sql 2005 not possible? |
 |
|
|
gison
Starting Member
5 Posts |
Posted - 2009-02-19 : 10:27:33
|
| hi visakh16, there are few concerns1. there are more than 1 hundred tables in the legacy system, some of them is customization from standard.2. there are some new tables on the new system. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-02-19 : 11:31:00
|
| then i'm afraid you've to use export import task or copy databse wizrad to move only reqd objects along with constraints, logins,... |
|
|
|
|
|
|
Best way to migrate data from 2000 to 2005?