Solved

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

Posted on 2014-04-10
2
240 Views
Last Modified: 2014-04-10
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
Comment
Question by:dpwhite
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 35

Accepted Solution

by:
Bembi earned 500 total points
ID: 39992677
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
 

Author Closing Comment

by:dpwhite
ID: 39992801
Thanks for the solution. This gives me the ability to migrate quickly and change the stored procedures at a slower pace.
0

Featured Post

Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

737 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question