Post reply

SQL aliase

  • February 19, 2014 at 8:31 am

    #396290

    Hi,

    i need to move the database to new server and application owner wants that specified database connection that I either can't or don't want to change.

    How can I do this easily without breaking other things that maybe using this connection and/or database?

    1)To my knowledge i think we can use aliases for this.Is that correct? or any other way to do.

    2)Is it posible to create the SQL Aliase for a Named instance when Sql is running on Dynamic port.?or do we need to use staic port?

    3)How to create SQL aliase for SQL Instances that are running on Cluster?is it same way as standalone or need to create on both nodes using sql configuration manager.

    Many Thanks

  • February 20, 2014 at 3:15 am

    #1690585

    Aliases are created on the client side. And in case of a cluster, we use SQL Server network name so irrespective of which node it runs, it is always accessible.

    We had migrated an entire instance to a new server and then renamed the new hostname and IP to previous ones. Please check if this will work for you. A consultation with sysadmins and business owners will lead you in correct direction.

    If you plan to migrate this single database to an already 'in-use' instance, then I think you will need to change the config for the application. but if you are using a system DSN to connect to SQL, you can change the address there and you are all set but all depends upon how currently your application is connecting to DB server.

    You can give some details and other expert friends will give some more sound advice.

    Thanks

    Chandan

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply