Comments
Sort by recent activity
Can you try installing again from this installer?
If that doesn't work, I would try running the installer again, but with logging to see if that provides any clues. You'll need to run it with this command line -
SQLToolbelt.exe log D:\Logs\mylog.txt
Obviously you can change the logfile path to be whatever you want. Once you've got the log, I'd have a look to see if there is anything obviously wrong in there. / comments
Can you try installing again from this installer?
If that doesn't work, I would try running the installer again, but with logging to see if that provides any clues. You'll need to run it with this ...
JDenman wrote: »
Okay that's what I expected. So there's currently no step to actually create the database itself - that's something we'd have to create a custom step for and use before the RedGate deployment step?
Yes, that's correct. / comments
JDenman wrote: »
Okay that's what I expected. So there's currently no step to actually create the database itself - that's something we'd have to create a custom step for and use before the Re...
You could modify your Octopus Deploy deployment process to include a pre-deployment step that creates the database. For instance, you could create a PowerShell script that uses the Invoke-Sqlcmd cmdlet to execute a SQL script on the server. Your SQL script could do something like the following - IF NOT EXISTS (SELECT 1 FROM sys.databases WHERE name = 'myDatabase')
BEGIN
CREATE DATABASE [myDatabase]
--You could also create any filegroups, etc here
END
Does that help? / comments
You could modify your Octopus Deploy deployment process to include a pre-deployment step that creates the database. For instance, you could create a PowerShell script that uses the Invoke-Sqlcmd cm...
Sadly not, I'm afraid. / comments
Sadly not, I'm afraid.
Theoretically it would be possible to parse the Changes.html file to retrieve a list of objects. In the middle of the file, you should see a JSON object defined where you see
var ___comparisonModel =
There are collections named createdObjects, droppedObjects, modifiedObjects and identicalObjects - you could pull the object names out of here if you wanted to. I'm not sure how to go about writing a Powershell script to do this, but it may well be possible. / comments
Theoretically it would be possible to parse the Changes.html file to retrieve a list of objects. In the middle of the file, you should see a JSON object defined where you see
var ___comparisonModel...
Hi Chris,
Unfortunately DLM Automation can't do this at the moment so I've made a note of this on our system as a feature suggestion.
If your need for the list is related to keeping track of schema changes, have you considered trying DLM Dashboard? / comments
Hi Chris,
Unfortunately DLM Automation can't do this at the moment so I've made a note of this on our system as a feature suggestion.
If your need for the list is related to keeping track of schema...
Hi Stephen,
Unfortunately this is a known issue with ID SDOC-1649. At the moment, to get the dependency to be listed you'll need to include the database that the object is in.
Sorry. / comments
Hi Stephen,
Unfortunately this is a known issue with ID SDOC-1649. At the moment, to get the dependency to be listed you'll need to include the database that the object is in.
Sorry.
I'm not overly familiar with merge replication, but have you tried committing the rowguid column to source control? That would certainly prevent it being dropped. My understanding is that if a table has a uniqueidentifier column with the rowguidcol property set, that column will be used for this purpose in replication. / comments
I'm not overly familiar with merge replication, but have you tried committing the rowguid column to source control? That would certainly prevent it being dropped. My understanding is that if a tabl...
Yes, so essentially you would have the rowguid column in each environment. / comments
Yes, so essentially you would have the rowguid column in each environment.
That's strange. It looks like you've got things set up correctly. I've asked our support team to create a support ticket for you as I think this is going to need a more detailed investigation. You should hear something regarding this shortly. / comments
That's strange. It looks like you've got things set up correctly. I've asked our support team to create a support ticket for you as I think this is going to need a more detailed investigation. You ...