Effective in version 10.0, in the Developer tool, you can switch the connection of a relational data object or customized data object to use a different relational database connection. After you switch the connection, the Developer tool updates the connection details for the data object in all Read, Write, and Lookup transformations that are based on the data object. You might want to switch the connection when you migrate from one database to another and want to simultaneously update the existing mappings to use the new connection.
You can switch a connection to one of the following connection types:
Microsoft SQL Server
The following image shows the dialog box that you use to switch a connection:
For more information, see the "Connections" chapter in the