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 |
|
lalbatros
Yak Posting Veteran
69 Posts |
 Posted - 2008-06-02 : 03:13:19
|
| Hello,Our IT infrastructure people have already moved and renamed my sqlServer a few times.This is giving me more and more headaches.When this happens, I have to modify some VB applications and recompile them.I have to change some path in some job steps.I have to re-connect Access applications and maybe redistribute them.And I have a lot of worry I could forget something and get into troubles.And last but not least, I should not forget to mention the hundreds of excel files and their pivot tables based on these databases.How would you organize yourself to be prepared for a server being renamed or moved?I thought that it might be possible to have king name translation somewhere, for example.But I have not seen a solution till now.Thanks for your suggestions. |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2008-06-02 : 03:18:18
|
| Most things can get their connections from something external like an ini file (held on a shared drive).If you use odbc then you can create an odbc connection for the machine and just change that rather than hard code it in the app (I don't like doing that).You can also create an alias for the serveer using the client connectivity manager.How do you connect to a test server before release? Its's the same problem.==========================================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. |
 |
|
|
lalbatros
Yak Posting Veteran
69 Posts |
Posted - 2008-06-02 : 05:25:37
|
| Thanks for hinting me at aliases.I did not know about that and it will be very useful.Unfortunately, I just tried using an alias with excel.When creating a pivot table, the alias is effectively used, this was encouraging.However, when rederecting the allias to another server, it did not change the results in the table.I found out that Excel first translates the alias, and then stores the real adress in the "sourcedata" property of the pivottable. That's realy bad luck, since it means that when refresheing the pivottable, excel always reconnect to the original server. This implies that I will have to reconnect manually every files (waiting for request for the users). The name of the alias is correctly stored in the sourcedata property, but it is not used. |
|
|
|
tosscrosby
Aged Yak Warrior
676 Posts |
Posted - 2008-06-02 : 11:31:39
|
| Depending on your organization and the reasons behind the moves, why not rename the new server to the original server name (also IP)? I've done this many times, created a new server, did an install of SQL and when the time came to flip the switch, had infrastructure rename the server nad the IP to the same as the original. No headaches!Terry |
|
|
|
lalbatros
Yak Posting Veteran
69 Posts |
Posted - 2008-06-02 : 15:30:11
|
| Yes that would be great!But several servers are merged together.In addition, there are some conversion issues (2000=>2005) that make a schedule difficult. |
|
|
|
|
|
|
|
|
server renamed, any medicine for headaches ?