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 |
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
 Posted - 2009-04-13 : 12:03:19
|
| its a Oracle to SQL MigrationMigration we are adding an additional date column which will identify the version of the record. What is the simple and best way to do this and we are talking about approximately 500 million records per table which needs to be updated for this column.ArnavEven you learn 1%, Learn it with 100% confidence. |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-04-14 : 22:54:49
|
| Update records in batches not whole single transaction. You also may want to defrag index after it is done as you are prone to internal fragmentation. |
 |
|
|
Rajesh Jonnalagadda
Starting Member
45 Posts |
|
|
|
|
|
Oracle to SQL Migration approach