Comments
Sort by recent activity
You can get some versions here: https://www.red-gate.com/products/old-versions
If you want to get a specific one, then let me know and I'll chase it down.
/ comments
You can get some versions here: https://www.red-gate.com/products/old-versions
If you want to get a specific one, then let me know and I'll chase it down.
Is this working for you? Which SSMS version do you have that caused issues with v9? / comments
Is this working for you? Which SSMS version do you have that caused issues with v9?
Confirmed. Comments are misaligned. / comments
Confirmed. Comments are misaligned.
A database snapshot or a SQL Compare snapshot? / comments
A database snapshot or a SQL Compare snapshot?
This would not be a DLM function, but just a T-SQL call. You could use a SQLCMD step in your build/release tool, or a PoSh step, and call the CREATE DATABASE AS SNAPSHOT OF command. / comments
This would not be a DLM function, but just a T-SQL call. You could use a SQLCMD step in your build/release tool, or a PoSh step, and call the CREATE DATABASE AS SNAPSHOT OF command.
OK, I need more information about what you did. I created a new SCA project and deployed it to a database. This worked fine with the SCA build and release tasks (v3) for the table. I then added a new column, as you did, and deployed it. That worked. Next, I added an index on the target, then added another new column on the dev side and deployed it. This also succeeded, even though there was drift on this table. Could you have otherwise altered this table (my_table), between deployments? I'm wondering what drift check you're catching. If you run a SQL Compare from the dev db to the prod one (or target), what comes back? / comments
OK, I need more information about what you did. I created a new SCA project and deployed it to a database. This worked fine with the SCA build and release tasks (v3) for the table. I then added a n...
Apologies for the issues. I haven't seen this, but I haven't done an SCA deploy lately with VSTS. I'll try to give this a test soon and confirm. / comments
Apologies for the issues. I haven't seen this, but I haven't done an SCA deploy lately with VSTS. I'll try to give this a test soon and confirm.
This works for me. Note that your post has the "DECLARE @... TABLE" on the commented line. I assume that's not the case in SSMS. Highlight the code, then format.
Prompt 9.1.10 [image] / comments
This works for me. Note that your post has the "DECLARE @... TABLE" on the commented line. I assume that's not the case in SSMS.Highlight the code, then format.
Prompt 9.1.10
I was thinking to use SQL Compare,or even run a deployment to the Shadow database, using the SCA package that's created. Just point the .ps1 to the shadow database and update things. I haven't gotten in this situation, and not sure I can recreate it. Haven't had time today, but perhaps I can try to upgrade an old project and see what happens. / comments
I was thinking to use SQL Compare,or even run a deployment to the Shadow database, using the SCA package that's created. Just point the .ps1 to the shadow database and update things.I haven't gotte...
The Shadow db is what is compared. This should be updated to the current version. You could use Compare to do this, but I think you could specify a new Shadow to "reset" the comparison / comments
The Shadow db is what is compared. This should be updated to the current version. You could use Compare to do this, but I think you could specify a new Shadow to "reset" the comparison