Comments
Sort by recent activity
Hi @Gadge,
this is how SQL Data Compare could work. Both the same and different networks (two SQL Server instances). The command line, is the application itself. So you need to setup at least in one place the tool.
hope this helps,
ale / comments
Hi @Gadge,
this is how SQL Data Compare could work. Both the same and different networks (two SQL Server instances). The command line, is the application itself. So you need to setup at least in on...
if you're using this, you can setup the following setting:
DLMAutomationDeleteExistingFiles = True
Did you try to change it? / comments
if you're using this, you can setup the following setting:
DLMAutomationDeleteExistingFiles = True
Did you try to change it?
Hi @JDenman,
I didn't get it actually. The DLM Automation is installed where? Have you also a SQL Source Control somewhere or are you using just the DLM Automation for packaging? How this is related to reading the sql file for users and SQL Compare? And what do you mean with "Leave artifacts from SQL Compare"?
I'm really sorry for the questions, but I could not understand, and I'd like to do so, because your pipeline made me curious [image]
The database where your're getting the user from is a dev database? Would you like to notify the dev team or you need to compare users with a test/production environment?
cheers,
ale / comments
Hi @JDenman,
I didn't get it actually. The DLM Automation is installed where? Have you also a SQL Source Control somewhere or are you using just the DLM Automation for packaging? How this is relate...
hi @mortenma71,
the "post deploy" scripts cannot be executed after the data comparison. We had the same requirements in our company and we started to apply migration scripts (feature of Sql Source Control, latest versions). With them, we inject the data creation after (or instead of) some structural change or else adding just a dedicated migration scripts with only data to send to the target environment.
Unfortunately, this solution become not so useful if you're deploying to a multi customer environment, because in that case you need to get a script which is often different for each customer. Additionally, is completely useless if you don't have a Sql Source Control license. In this scenario, you have to make something custom (like a powershell script for comparing and, then, applying scripts) or you can use a deployment tool, like octopus deploy.
If you don't want to buy octopus, Source Control or using PowerShell is not an option, you can let SQL Data Compare create the script for you and, then, append manually the post deploy "INSERTS" to it. So you will execute the generated script instead of comparing via tool.
hope this helps / comments
hi @mortenma71,
the "post deploy" scripts cannot be executed after the data comparison. We had the same requirements in our company and we started to apply migration scripts (feature of Sql Source ...
Hi @Ravin,
The first picture, depicts the filter settings, and you've removed the users. The second picture, if I remember well, it's about the database comparison options file (described here).
Could you please check how the users are filtered in the filter.scpf file? You can find it into your SQL Source Control repository.
I think that the filter file is not configured correctly if you want to include users and roles. You should to check also the Users box. / comments
Hi @Ravin,
The first picture, depicts the filter settings, and you've removed the users. The second picture, if I remember well, it's about the database comparison options file (described here).
Co...
Hi @Ravin,
what do you mean with "when I try to deploy"?
what are you using for deploying your db? The image you posted belongs to SQL Source Control (if I get it correctly). / comments
Hi @Ravin,
what do you mean with "when I try to deploy"?
what are you using for deploying your db? The image you posted belongs to SQL Source Control (if I get it correctly).
Hi @CrossSlide,
reading the documentation , there is some notes to pay attention for. I don't think that trying to do the "known issues" things actually hangs the restore process, but maybe the list could help you in some way.
Another suggestion, since we're on Windows, could be to execute the comparison tool "as Administrator".
Last but not least, you can try to setup a log file, as described here, and look for any message on it.
Hope this will help you discovering the issue. / comments
Hi @CrossSlide,
reading the documentation , there is some notes to pay attention for. I don't think that trying to do the "known issues" things actually hangs the restore process, but maybe the lis...
Hey @shollingshead,
I guess this is not really related to the product. If you try to connect to Azure SQL Database using SQL Server Management Studio, are you able to connect via integrated security, since you're out of the domain with your local/roaming credential? / comments
Hey @shollingshead,
I guess this is not really related to the product. If you try to connect to Azure SQL Database using SQL Server Management Studio, are you able to connect via integrated securit...
Hi @bassofa,
not with one click, actually. Did you notice the "switch" button between the source and the destination database? You can compare S1.DB1.TB1 (-->) S2.DB2.TB2 applying only the additions/modifications and, then, switch and re-compare with S2.DB2.TB2 (-->) S1.DB1.TB1 only with deploying the additions/modifications. In both the comparison sessions, you must uncheck the "only in the right" objects (deletions).
hope this helps, / comments
Hi @bassofa,
not with one click, actually. Did you notice the "switch" button between the source and the destination database? You can compare S1.DB1.TB1 (-->) S2.DB2.TB2 applying only the addition...
Glad to get it! [image] / comments
Glad to get it!