March 24, 2005 at 4:31 pm
My dev environment is a single SQL Server. My production team has just informed me that when we move my databases into production (in the next 2 weeks) they will be placed on an instance of SQL Server that is clustered.
Is this going to impact my stored procs, DTS packages, functions, etc?
I'm working with 2 databases that are sharing information, usually via Views, but also via direct table access. I know that if the database name changes, then everywhere I have DBname.dbo.ViewName will have to be changed to reflect the new DBname. Is there any other aspect of references a second database that is going to bite me in this move to a clustered environment?
Thanks for any insight!
Jana
March 24, 2005 at 4:45 pm
Anything that references file paths (potentially DTS packages), may be impacted. But this is not a new concern if you are moving from one server environment to another.
From within SQL Server everything should appear the same. Clients should also see the SQL Server virtual server as they would a standard physical server. Only in rare cases have I seen an issue and those were bugs.
K. Brian Kelley
@kbriankelley
March 25, 2005 at 9:25 am
When you access a cluster, you make a connection to the virtual server. Say below is a connection string
cn.open "driver={SQL Server};Server=Server_name;uid=user;pwd=;"
The only thing changes is that if it is a stand alone server with a default server, you put in the server_name while in a cluster you will provide the virtual name. Everything within your instance will be the same. Hence, as Brian advised, there won't be any change with procedures, views etc.
Regarding the drives, if you are connecting to the shared drives (which are dependent on your SQL Server resource), then you won't have to change anything. The shared drives will be available with the same logical drive letter irrespective of the server on which the cluster is running. If you are accessing the local drives, as Brian said, it would be impacted.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply