SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Yet another way to include portability on DTS packages


Yet another way to include portability on DTS packages

Author
Message
Jags2001
Jags2001
SSC Veteran
SSC Veteran (207 reputation)SSC Veteran (207 reputation)SSC Veteran (207 reputation)SSC Veteran (207 reputation)SSC Veteran (207 reputation)SSC Veteran (207 reputation)SSC Veteran (207 reputation)SSC Veteran (207 reputation)

Group: General Forum Members
Points: 207 Visits: 128
If you install SQL Server Accelator for BI (SSABI) -- if it is still available - the implementation of its generated DTS packages are all driven by variables, including INI files.



John Palmer-427485
John Palmer-427485
Forum Newbie
Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)

Group: General Forum Members
Points: 1 Visits: 18
Speaking of DTS package portability, we use the SQL Server Client Network Utility (cliconfg.exe, installed with Windows) to create an "alias" for our DEV/TEST/PROD SQL Servers on all servers and workstations. For example, the alias we use is "CorporateSqlServer01", and on DEV servers and developer workstations it points to our DEV SQL Server; on TEST servers it points to our TEST SQL Server; and on PROD servers it points to our PROD SQL Server.

This has been a great help to us for deploying and migrating applications as well as DTS packages because the connection string never has to change:

"Data Source=CorporateSqlServer01; Initial Catalog=our_app_database; Integrated Security=SSPI"



Using the same concept, we create aliases for the file servers and what-nots in the HOSTS file, so UNC paths can be \\localhost\share or \\CorporateFileServer01\share and so forth. Again, so code and DTS packages can be migrated from server to server regardless of their DEV/TEST/PROD environment. Similarly, you can create a HOSTS alias for CorporateStateServer01, for example, that points to your ASP.NET state server (if you use one).
taulpall
taulpall
SSC Rookie
SSC Rookie (25 reputation)SSC Rookie (25 reputation)SSC Rookie (25 reputation)SSC Rookie (25 reputation)SSC Rookie (25 reputation)SSC Rookie (25 reputation)SSC Rookie (25 reputation)SSC Rookie (25 reputation)

Group: General Forum Members
Points: 25 Visits: 27
John,

I'm very thankful that you posted this info about aliasing server names. I am about to setup a testing environment so I have an immediate use for this.

Thanks again,
taulpall
Yelena Varshal
Yelena Varshal
SSCertifiable
SSCertifiable (5.5K reputation)SSCertifiable (5.5K reputation)SSCertifiable (5.5K reputation)SSCertifiable (5.5K reputation)SSCertifiable (5.5K reputation)SSCertifiable (5.5K reputation)SSCertifiable (5.5K reputation)SSCertifiable (5.5K reputation)

Group: General Forum Members
Points: 5534 Visits: 597
This is a GREAT idea with alises.
The reason I don't use it is that we try to make dev, test and production environment with as different names as possible including different database names. The reason for that is that the superusers who test the SW would not accidentally confuse test and production and would not enter production data into the test database.


Regards,
Yelena Varshal

mosaic-263591
mosaic-263591
SSC-Addicted
SSC-Addicted (446 reputation)SSC-Addicted (446 reputation)SSC-Addicted (446 reputation)SSC-Addicted (446 reputation)SSC-Addicted (446 reputation)SSC-Addicted (446 reputation)SSC-Addicted (446 reputation)SSC-Addicted (446 reputation)

Group: General Forum Members
Points: 446 Visits: 566
Bill Whitman,

This is a useful solution that allows the production pakage to run while at the same time working on the development of the next version of the package - thanks!
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search