SQL database scripting tool ApexSQL Script natively integrates with the Git, Mercurial, Perforce, Subversion, and Team Foundation Server source control systems.
ApexSQL Script allows to export complete SQL database, or just a couple of its objects, to one of the mentioned source control systems by following these steps:
-
Connect to a SQL Server, select a SQL database in the New project window and click the Load button:
-
By changing Views, to Structure or Data, in the Home tab, select the desired objects and data that will be included in exporting to source control:
-
When all desired objects are checked, click the Script button, in the Home tab, of the main window, to run the Script wizard:
-
In the next two steps choose the Scripting mode – Structure and data in this case and the Output type – Source control output type as a database will be exported to source control, and click the Next button:
-
In the next step, the Include dependent objects option is checked by default, which means that all dependent objects will be included, or uncheck it if there is need to for them:
-
In the final step of the Script wizard, the source control settings need to be set with a click on the Setup button:
-
The Source control wizard is opened, and the following settings are pretty much known to the users who have had the experience with source control, selecting a source control type and setting up the credentials and repository parameters:
Once the parameters are all set up, the final step in ApexSQL Script is to click on the Commit button and the exporting to source control repository will begin:
-
Once finished, the Results dialog will be shown:
Source control is essential in all applications that have many different release versions of a product. ApexSQL Script allows users to explore the changes and SQL script iterations over different versions by leveraging common source control providers.
March 4, 2015
