Support Center

Name is required.
Email address is required.
Invalid email address
Answer is required.
Exceeding max length of 5KB

__MigrationLog table schema (namespacing)

Mark Davies Nov 09, 2016 04:21AM AEDT

Is it possible to configure a ReadyRoll project to use a __MigrationLog table in a schema other than dbo, so that more than one application could manage and version control its database schema within a shared database?

Alternatively, is it possible to use a table named something other than __MigrationLog, to the same end?

Apologies if this is documented somewhere; I have tried to find an answer, and failed.

Thank you,

Mark

Up 0 rated Down
Daniel Nolan Nov 11, 2016 07:27PM AEDT ReadyRoll Agent

Hi Mark,

Firstly, apologies for the delay in responding. I’ve had a chance to look into whether it’s possible to deploy the [__MigrationLog] to an alternate schema, and I’m pleased to report that this is indeed configurable.

In order to set a custom schema name, edit your project file (.sqlproj) and add the following under the root node:

<PropertyGroup> <MigrationLogSchemaName>MySchema</MigrationLogSchemaName> </PropertyGroup>

The next time you deploy your project, the MigrationLog] will be created within the specified schema (as will the related view object, [MigrationLogCurrent]). If you’re looking to split your shared database into multiple projects (i.e. so that each project only includes the objects from a specific schema), have a look at the following forum post to find out how to setup project filers:
https://forums.red-gate.com/viewtopic.php?f=199&t=80015&sid=5d0133fd3e204b145b25dc32683e4f33

Any questions please let me know.

Best Regards,

Daniel Nolan

Post Your Public Answer

Your name (required)
Your email address (required)
Answer (required)
readyroll.support@red-gate.com
http://assets2.desk.com/
false
readyrollsql
Loading
seconds ago
a minute ago
minutes ago
an hour ago
hours ago
a day ago
days ago
about
false
Invalid characters found
/customer/en/portal/articles/autocomplete