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 |
|
laddu
Constraint Violating Yak Guru
332 Posts |
 Posted - 2011-07-05 : 11:16:53
|
| Hi,I am planning for a data migrationWe have a application database - SQL Server 2008 (290 tables)Application new version changes includes21 new tables and changes for 14 existing tables.my plan - please correct me whether below plan is ok. Thanks!1) Restore existing database in new datacenter (we are moving existing prodution database to different databse)2) Transfer all logins and sql jobs (we have no ssis packages)3) Apply all delta scripts and then apply migration change scripts.4) Test the applicaton |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2011-07-05 : 11:20:21
|
| You may want to test any other applications/processes that use the database you are migrating as well unless it is truly standalone. |
 |
|
|
laddu
Constraint Violating Yak Guru
332 Posts |
Posted - 2011-07-05 : 11:26:48
|
| Only one application uses the database.Application new version includes new tables and changes to few existing tables.No change in SQL server version (2008 only) |
|
|
|
Sachin.Nand
2937 Posts |
Posted - 2011-07-06 : 05:03:36
|
| I would rather skip step 2 and instead the restore the existing Master DB and MSDB DB to the datacenter.PBUH |
|
|
|
|
|
|
migration