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 |
|
gangadhara.ms
Aged Yak Warrior
549 Posts |
 Posted - 2011-03-22 : 22:01:38
|
| Dear All,We are planning the migrate the data warehouse Db to SQL server 2008 shared server environment from SQL server 2005.We are planning to migrate one DB along with SSAS,and SSIS packagesCan you please help in compiling the list of items we need to move and where we need to make the changes to code.Thanks,Thanks,Gangadhara MSSQL Developer and DBA |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2011-03-22 : 22:16:08
|
| - Registered logins that have access to the database you're moving- SQL Agent jobs that access it, including maintenance like backups or index reorg/rebuild- If you have linked server queries that access that database, you may need to edit them (OPENQUERY or 4-part name references)- Cross-database code references (3-part names) on the original server- Report data sources- ODBC data sources, if used by applications, MS Access, or ExcelThis may not be a complete list, but logins and jobs are usually the first things to be missed. The next 2 I listed are database interdependencies that may break, or need to be broken, during the move. You'll also have to look at your applications and SSIS packages for connection strings that need to be changed. That's what the last 2 on my list are part of: any external components that connect to it. |
 |
|
|
|
|
|
virtual server migration