We are in the process of migrating our systems to a new environment, with new server names, and, as such, need to modify all users' connection properties within Studio. Is there a way to modify these connection properties in an external file in Windows somehow? I would like for our Desktop Support team to be able to write a batch process to be able to mass-update this file to modify the connection properties for the new servers. Possible?
1) One option is to distribute an .xml file that contains the connection profile with the new server name in the profile definition and users would import it into their Studio or Studio Express. During the import, be sure to check the box "Overwrite existing connection profiles with same names". The Export and Import options are on the Data Source Explorer toolbar.
2) The other option is to pre-configure connection profiles that are used during the install process. There is a template in the /config directory of the Windows install unzipped media. During install it will ask if you want to pre-configure connection profiles and locate the configuration file. This would be an approach to distribute Connection Profiles to your users during install.
Are these connection profiles stored in a file somewhere on the OS?
ok, for option 1 above, each user may have a different name for a given connection to a particular server, since these names are customizable. how would we address this with a generic .xml file distribution? we don't know what the entry name is for every user. the only think that would be consistent would be the server name.
It will import any new connection profiles or overwrite existing ones that match the name. Possibly another option is to modify the host files that map the database server names?