Configure SQL Tran
Last updated
Last updated
In SQL Tran, open a project. Then, in the bottom left corner click on the user icon and then click on the „Project settings“.
On the Settings screen select the „Database connections“ section, which will allow you to configure your source and target databases, as well as the corresponding authentication details. Once you are done click the „Test connection“ button to make sure SQL Tran can connect to your database.
The purpose of source staging connection is to provide the live access to the source database. We use it to run tests against so DO NOT USE SOURCE PRODUCTION connection here.
The purpose of target staging connection is to provide the live access to the target database. We use it to run tests against so DO NOT USE TARGET PRODUCTION connection here.
For tests to be successful, target staging connection needs to contain exact same data source staging connection has. You can use Omni Loader for that purpose.
After your tests pass with all the required objects and data in the target staging connection, you can create all the objects without any of the comments used to explain the changes. Target production connection is the database where you should create such code.
