Option to store the "Version", "Linked to" and "Migration folder" in a file not the database
Currently Source Control information is stored in database extended properties in the database being source controled. This requires Alter Database. In production those of us who use RedGate for Source Control, do NOT have Alter database because only the sys admins have that. And they do not want to bother with RedGate as they are just acting as auditors not database developers in production. Other environments we have full rights, just not production. It would be great to have an option to store the "Version", "Linked to" and "Migration folder" in a file not in Extended properties in the database.
Sorry that this has taken so long to deal with, but I’m pleased to say that the latest version of the migrations feature no longer requires extended properties on your database.
This means that as of version 5.1.1 of SQL Source Control, Alter Database permissions are no longer required.
Mike Upton
Technical Lead | SQL Source Control