Version control table rows as part of your repository. Use it for small, static or semi-static reference tables and enumerations that must deploy alongside schema.<\/p>\n
Lookup tables (aka static tables, aka reference tables): statuses, countries, tax rates, feature flags.<\/p>\n<\/li>\n
Seed or configuration data required for app startup.<\/p>\n<\/li>\n<\/ul>\n
Avoid for high-churn or large transactional tables. A warning appears above 1,000 rows.<\/p>\n
You \u201clink\u201d a table’s data to source control. VersionSQL scripts those rows to a file in your repo. You can see data changes during a commit by examining file diffs. Deployments read the files and apply changes to the target database.<\/p>\n
Table must have a primary key<\/strong>.<\/p>\n<\/li>\n<\/ul>\n Right-click a table \u2192 VersionSQL \u2192 Link Static Data<\/strong>.<\/p>\n<\/li>\n The menu shows a checkmark<\/strong> when the table is linked.<\/p>\n<\/li>\n To stop scripting this table’s data, use Unlink Static Data<\/strong>.<\/p>\n<\/li>\n<\/ol>\n Upsert (insert\/update\/delete):<\/strong> Default. Generates a script that fills a temp table with rows and runs separate insert, update, and delete statements to keep data in sync.<\/p>\n<\/li>\n Inserts only:<\/strong> Generates a long list of insert statements, with a truncate statement at the top (disabled by default). Less flexible, but similar to the output of other tooling. Useful if your deployment pipeline or auditors require a flat file of inserts.<\/p>\n<\/li>\n<\/ul>\n Choose the format per connection in settings.<\/p>\n Files are saved under a data folder in your repo. Default: Folder name is configurable (choose from presets or type your own).<\/p>\n<\/li>\n<\/ul>\n Connection Settings \u2192 Advanced \u2192 Static Data<\/strong><\/p>\n Add or remove linked tables.<\/p>\n<\/li>\n Choose Script format<\/strong> and Data folder<\/strong>.<\/p>\n<\/li>\n<\/ul>\n Linked tables generate file diffs when data changes.<\/p>\n<\/li>\n The History<\/strong> view for a linked table shows both schema and data<\/strong> changes together.<\/p>\n<\/li>\n<\/ul>\n Static data files are applied during deployment.<\/p>\n<\/li>\n Deletions are disabled by default and can be enabled by changing the Link or Unlink a Table<\/h2>\n
\n
Script Formats<\/h2>\n
\n
Folder and Files<\/h2>\n
\n
Data<\/code><\/strong>.<\/p>\n<\/li>\nConfigure<\/h2>\n
\n
Commits and History<\/h2>\n
\n
Deployments<\/h2>\n
\n
StaticDataEnableDeletes<\/code> <\/strong>SQLCMD variable at the top of the deployment script.<\/p>\n<\/li>\n<\/ul>\n","protected":false},"author":1,"featured_media":0,"parent":98,"menu_order":11,"comment_status":"closed","ping_status":"closed","template":"","meta":{"inline_featured_image":false,"footnotes":""},"doc_tag":[],"class_list":["post-1762","docs","type-docs","status-publish","hentry"],"comment_count":0,"_links":{"self":[{"href":"https:\/\/www.versionsql.com\/help\/wp-json\/wp\/v2\/docs\/1762","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.versionsql.com\/help\/wp-json\/wp\/v2\/docs"}],"about":[{"href":"https:\/\/www.versionsql.com\/help\/wp-json\/wp\/v2\/types\/docs"}],"author":[{"embeddable":true,"href":"https:\/\/www.versionsql.com\/help\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.versionsql.com\/help\/wp-json\/wp\/v2\/comments?post=1762"}],"version-history":[{"count":4,"href":"https:\/\/www.versionsql.com\/help\/wp-json\/wp\/v2\/docs\/1762\/revisions"}],"predecessor-version":[{"id":1766,"href":"https:\/\/www.versionsql.com\/help\/wp-json\/wp\/v2\/docs\/1762\/revisions\/1766"}],"up":[{"embeddable":true,"href":"https:\/\/www.versionsql.com\/help\/wp-json\/wp\/v2\/docs\/98"}],"next":[{"title":"Scan for Uncommitted Changes","link":"https:\/\/www.versionsql.com\/help\/documentation\/features\/scan-for-uncommitted-changes\/","href":"https:\/\/www.versionsql.com\/help\/wp-json\/wp\/v2\/docs\/1772"}],"prev":[{"title":"View Changes","link":"https:\/\/www.versionsql.com\/help\/documentation\/features\/view-changes\/","href":"https:\/\/www.versionsql.com\/help\/wp-json\/wp\/v2\/docs\/99"}],"wp:attachment":[{"href":"https:\/\/www.versionsql.com\/help\/wp-json\/wp\/v2\/media?parent=1762"}],"wp:term":[{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/www.versionsql.com\/help\/wp-json\/wp\/v2\/doc_tag?post=1762"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}