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 |
|
VickMorrow64
Starting Member
1 Post |
 Posted - 2010-11-15 : 20:36:16
|
| Have a need to move over 100 sqlserver 2008 R2 databases from customer1 to customer2- they have same table layouts. Initially there will be a backload to populates history then incrementals from that point forward. Unsure if all columns will be pulled from all tables. Customer2 is open to receiving ank kind of file or even a sql backup. What is the best way to move 1 to 2 terrabytes of data? Do you like the idea of delivering a sql backup. There will be minimal transformation - an entityid will be added. I realize both customers might not be on same release of sql server at same time. Customer 1 (where source is stored) generally upgrades quicker and uses latest releases - so there may be a downward compatability issue. Any feedback is appreciated |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2010-11-16 : 00:27:00
|
| If the customers are not on the same release, if customer1 is on a higher release of SQL Server than customer2, and if customer2 receives the data from customer1, then a SQL backup is not a viable option. Backups are not backwards compatible.Compressed backups are the fastest way to move databases. If you've got 1TB of data, then the compressed backups should total about 100GB. Due to backwards compatibility level issues with backups, you need to ensure that customer1 and customer2 are at the same level of SQL Server. If customer1 wants to upgrade, then make sure customer2 also upgrade before they need to receive a new set of data.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
 |
|
|
|
|
|
moving large volumes of data - help