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 |
|
apps_1482
Starting Member
3 Posts |
 Posted - 2006-11-13 : 08:08:22
|
| Hey,Can anyone direct me in achieving migration from IBM DB2 to SQL server. What all steps to be taken? P.S. Database is huge around 1.2 TB |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-11-13 : 08:46:27
|
| Buy hardware. More than you can imagine.Investigate all triggers, indexes, tables, files, everything that is in use today in DB2.Read about replacements and their impact, such as other datatypes, before transferring the data.Transfer one table first, for testing. Rewrite one program that work against this table, to T-SQL query.Calculate the cost for transferring including the work hours needed to do this. Multiply by 2.5 to be sure.Peter LarssonHelsingborg, Sweden |
 |
|
|
apps_1482
Starting Member
3 Posts |
Posted - 2006-11-13 : 09:25:51
|
| Hey Peter,I appreciate your reply.But, my major area of concerns are:1)How easy it is to use DTS?2)Is there any provision to handle code page conversion in DTS?regards,gaurav |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-11-13 : 09:43:45
|
| No, there is no problem using DTS against DB2.Time is of no importance...Peter LarssonHelsingborg, Sweden |
|
|
|
apps_1482
Starting Member
3 Posts |
Posted - 2006-11-13 : 12:00:28
|
| hey,Will appreciate the solution for second query i.e. regarding code page handling in DTS |
|
|
|
|
|
|
|
|
Migration from IBM DB2 to SQL server