[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 248
  • Last Modified:

How do I centralize Hostname/IP address so they can be changed in one place for all stored procedures?

Historically, our development team hard coded the IP address or hostname into each stored procedure. I want to point all of the stored procedures to a centralized location so that I can change these values once, make a server change, and still have all of the stored procedures function correctly. Can anyone give me some insight as to how this can be accomplished? We have over 300 stored procedures and it appears that they will have to be updated manually.
0
dpwhite
Asked:
dpwhite
1 Solution
 
BembiCEOCommented:
A common upgrade problem. I guess the best solution is to use an alias name for our solution and register the alias name in your DNS as CNme (or use local Alias names for SQL server.). This way the name is neutral and when the target changes, you either cahnge just the DNS or local alias.

The decision, if local alias or DNS name depends, if it is a server to server (SQL alias) or client to server (DNS) connection. SQL Alias has to be changed on each clients,which accesses the server, For IIS to SQL connections ok, but for clients, which has to find the SQL server better via DNS
0
 
dpwhiteAuthor Commented:
Thanks for the solution. This gives me the ability to migrate quickly and change the stored procedures at a slower pace.
0

Featured Post

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now