1. Home
  2. Help
  3. FAQ
  4. Scripting

Scripting

What object types does VersionSQL support?

VersionSQL will script the following object types:

  • Tables
  • Views
  • Stored Procedures
  • Scalar-Valued Functions
  • Table-Valued Functions
  • Sequences
  • Synonyms
  • User-Defined Data Types
  • User-Defined Table Types
  • Assemblies
  • Database triggers (DDL triggers)
  • SQL Server Agent jobs

Can I use VersionSQL to track changes on SQL Server Agent jobs?

Yes! Right-click on SQL Server Agent and select "Connect to Version Control" to set up a version control connection just like you would a database. From there, you can right-click again and select "Commit All Jobs" to save them all at once, or right-click individual jobs to take care of them one at a time.

Does VersionSQL generate CREATE or ALTER statements?

VersionSQL generates all scripts with CREATE statements

How do you export scripts from VersionSQL?

You can open the latest committed version of a database object from the repo, and perform a manual merge operation between the object’s script in the repo and the object in the database.

How do you generate change or deployment scripts?

VersionSQL is specifically for committing database scripts into version control that record the state of the database. A deployment script encodes not only the state of the database being committed, but also of the database to which it will be deployed. They are one-time-use scripts, not the archival type of script VersionSQL is geared towards.

Can I customize VersionSQL's folder structure?

To customize that folder structure, see the Scripting tab within Connection Settings – Advanced Options.

Can VersionSQL save SQL from a Dev DB and open them for execution on a Prod DB?

Yes, VersionSQL saves SQL from the DB to your version control server. For instance, GitHub, Bitbucket, SVN, etc. You can then open that SQL from within SSMS using VersionSQL’s Merge Latest from Repo feature, or by logging into your version control server directly.

Does VersionSQL support versioning table data?

Not at this time. VersionSQL versions schemas; it does not track static table data.

That said, this feature is on the backlog for development someday. Please send me an email me if you want this feature and I will bump it up.

What folder structure does VersionSQL use?

By default, VersionSQL creates the following structure within your version control host: root/VersionSQL/pc_name/db_server_name/db_name/db_owner/object_type
To customize that folder structure, see the Scripting tab within Connection Settings – Advanced Options.

Was this article helpful to you? Yes No

How can we help?