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?
Take a look at the documentation for the Deployment Script Generator feature.
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.