Activity overview
Latest activity by mjashton
Service Broker is not a programmable object?
I'm just starting out using SCA (already been using SSC) and importing my existing database, but ran into a problem with the default options when the database makes use of Service Broker Queues.The...
Ok, thanks for the info. The background to this question (and the other one you answered around idempotent data scripts) is that I have been trying to work around a problem involving getting automation working when one half of the comparison is a snapshot rather than a backup. Because a snapshot doesn't have any data this throws an exception using SQL Compare command line, but I'd hoped to be able to generate a synchronisation script that included the static data under source control. Using the SDK I could do a data comparison between a DB from snapshot and the source controlled folder, and I'd hoped to be able to use this comparison to create a drop-and-create approach to static data. I guess I need to move on to plan C, now that plan A and B have been ruled out.
Thanks again. / comments
Ok, thanks for the info. The background to this question (and the other one you answered around idempotent data scripts) is that I have been trying to work around a problem involving getting automa...
Thanks for the link - it obviously gets my vote! It seems impossible to make idempotent scripts (via automation) without this kind of feature, unless I'm missing something else. Thanks again. / comments
Thanks for the link - it obviously gets my vote! It seems impossible to make idempotent scripts (via automation) without this kind of feature, unless I'm missing something else. Thanks again.
Can no-one from RedGate confirm that static data is supposed to be written out as part of the database.SaveToFolder() operation? / comments
Can no-one from RedGate confirm that static data is supposed to be written out as part of the database.SaveToFolder() operation?
No-one? / comments
No-one?
Database.SaveToFolder doesn't include 'Data' folder?
I am doing the following, for experimentation purposes:var targetDb = new Database();
targetDb.RegisterForDataCompare(options.DbDirectory.FullName,null,Options.Default);
var dbInfo = targetDb.DbInf...
Are there any options for how to script out the data synchronisation script?
I can't find any options for how the script created by
provider.GetMigrationSQL
is structured. For example, with Schema Compare scripts you can specify options for
DropAndCreateInsteadOfAlter
to ...
A follow up:
I've attempted to edit the migration script (Migrations > Existing migration scripts > view/edit) to include the new dependencies that need dropping/adding before changing the table.
I've added the appropriate changes and clicked the 'save and close' button on the migration script, and it now appears within the 'commit' tab as something new to save to source control. However when I attempt to 'save changes' it Errors with
The migration script Covers changes to: tblCustomer. Script created at 2017-03-30 16:19. could not be found. It may have been deleted.
The script definitely appears in the 'Existing migration scripts' section, but maybe this is pointing to why it is no longer being used when creating a deployment script using SQL Compare? Has something become corrupt, and if so what is the best way to correct this. / comments
A follow up:
I've attempted to edit the migration script (Migrations > Existing migration scripts > view/edit) to include the new dependencies that need dropping/adding before changing the table.
I...
A deployment script is created to manage the changes between (a) a snapshot of last-live db and (b) current source-controlled version. We might create this script 3 or 4 times a week on a dev environment, and maybe once a week for a QA environment. At each of these deployments the db for that environment is restored to the last-live db, and the deployment script is run.
I believe in this scenario, whether the migration script has been run or not is reset each time with the restore of the db BAK? / comments
A deployment script is created to manage the changes between (a) a snapshot of last-live db and (b) current source-controlled version. We might create this script 3 or 4 times a week on a dev envir...
Why is migration script no longer being used for deployment
Our Source Control has a single migration script, created to handle the change of data-type to a field in a single table. Initially when using SQL Compare to create deployment scripts this migratio...