What are the challenges you face when working across database platforms? Take the survey
Options

ReadyRoll Core Visual Studio 2017 - How to "Mark as Deployed" / Set a "Baseline"?

tcdstcds Posts: 1 New member
In Microsoft Visual Studio Enterprise 2017 Version 15.2 (26430.16), I started a new ReadyRoll SQL Server Database Project, in the ReadRoll Core Edition window, Connected to an existing database, Imported from it which: a) created, in the "Migrations" Folder of my Project, a "0001_20170814-1710_myWindowsUserId.sql" File that contains the T-SQL create statements of all the objects in my database, b) created a "dbo.__MigrationLog" Table in my database and c) added a Row to that database with that "script_filename", "applied_by" of "myDomain\myWindowsUserId", "deployed" of "2" and "sequence_no" of "1". I then made a test change (added an Index) to my database, and in the ReadRoll Core Edition window, selected "Import and generate script" which: a) created, in the "Migrations" Folder of my Project, a "0002_20170814-1817_myWindowsUserId.sql" File whose only DDL statement is the one for the new Index, b) added a Row to my database with that "script_filename", "applied_by" of "myDomain\myWindowsUserId", "deployed" of "2" and "sequence_no" of "2". How do I specify that the first migration script (""0001_20170814-1710_myWindowsUserId.sql"") is the "baseline"?
Tagged:

Answers

Sign In or Register to comment.