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 |
|
dejjan
Yak Posting Veteran
99 Posts |
 Posted - 2005-11-20 : 09:42:52
|
| Hello everybody,we move our application to a different location in new hardware environment, so I want to prepare everything and than to turn off primary server, change name of the new one and than to start new server to work with application.My question is: - I will instal MS SQL Server Enterprise Ed. in new location and prepare everything for our application. When I want to move application and make the new server productional do I need to do anything else but to turn off old server, change name of new one and than to execute on new server: master..sp_dropserver 'InitialName'master..sp_addserver 'NameOfOldProduction', LOCALIs there any other update of system tables, or changing in registry, or smth else.Thanks in advance |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2005-11-21 : 05:44:31
|
| How does the application connect?Would be a lot easier if you could just tell it to connect to another server - would give you the ability to have a test server too.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
dejjan
Yak Posting Veteran
99 Posts |
Posted - 2005-11-21 : 11:07:27
|
| Application is very complicated, with many linked servers, DTS, jobs etc. So I must keep the same name of server. There is no way to change name of server. |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2005-11-21 : 13:38:18
|
quote:
Originally posted by dejjan
Application is very complicated, with many linked servers, DTS, jobs etc. So I must keep the same name of server. There is no way to change name of server.
Yes there is - depends if you want to do it though.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
dejjan
Yak Posting Veteran
99 Posts |
Posted - 2005-11-22 : 04:48:58
|
| The fact is that firm which create that application and give us support doesn't allow to change name of server. It is Bank application and it is huge and robust.So I don't have any choice here. |
|
|
|
|
|
|
|
|
Creating copy of SQL Server