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 |
|
david32
Starting Member
15 Posts |
 Posted - 2008-08-10 : 19:47:56
|
| Hi FolksIf I need to move a database to another server what would be the process for that?The situation seems complicated by the fact that there are 400+ clients that connect to the databases in different ways (ODBC, ADO.net etc) |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-08-10 : 20:47:15
|
| Use backup/restore or detach/attach to get the databases over. You'll also need to move logins (see my script: http://weblogs.sqlteam.com/tarad/archive/2008/06/24/How-to-transfer-SQL-logins-between-SQL-Server-2005-instances.aspx), jobs, DTS/SSIS packages, and anything else not contained inside the database. This could be transparent to the client if you use a DNS alias for the old server pointing to the new one. You'd need to involve your network people on that.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
 |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2008-08-12 : 01:40:30
|
| Other things to consider are: the different types of Password Policies, configurations and collation settings of the different serversJack Vamvas--------------------Search IT jobs from multiple sources- http://www.ITjobfeed.com |
|
|
|
|
|
|
moving a database