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

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.

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?