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?

VersionSQL does not provide a way to customize the folder structure. The default structure ensures that similarly-named databases across different servers are tracked independently without conflicts.

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?

VersionSQL creates the following structure within your version control host
root/VersionSQL/pc_name/db_server_name/db_name/db_owner/object_type

Was this article helpful to you? Yes No

How can we help?