Posts
Sort by recent activity
Specify the subfolder where objects are scripted when creating scripts folders from a database
A long time ago, we scripted our databases to scripts folders to add them to source control. At the time, we told sql compare to put table triggers in their own folder and it did. Our folder stru...
How do I filter out tables from data compare for a sql azure managed database?
Hi, I'm comparing a local db to a version of it in an Azure sql managed instance. Normally, when I run data compare on two databases, I can click the 'Tables & Views' tab to select only the tables...
Sql compare 13 flags GRANT EXEC as different than GRANT EXECUTE
I noticed the only difference in a stored procedure script that was being flagged by Sql Compare 13.1.11.5591 as different between the script and the server was EXEC vs EXECUTE in a grant statement...
BUG: Sql compare 13 flags GRANT EXEC as different than GRANT EXECUTE
I noticed the only difference in a stored procedure script that was being flagged by Sql Compare 13.1.11.5591 as different between the script and the server was EXEC vs EXECUTE in a grant statement...
"The path must be an empty folder" error
Maybe I'm missing something (quite likely) but isn't it possible to link sql source control 3 to an existing set of scripts? We've been using TFS and Sql Compare 9 to source control our database s...
SQL Compare not finding User-defined type script file
Hi, I have a user-defined table script file sitting in the path:Create Scripts\Types\User-defined Data Types\fileName.sql
SQL Compare is not seeing this file and notes it as missing from the script...
Variables aren't suggested after x number of lines
I find that about 125 lines away from where I've declared variables SQL Prompt no longer knows of their existence. Is it possible to customize this so that SQL Prompt reads the entire file even if...
Enhancement Request
Provide support for SQL Prompt within scripts edited in Sql Multi Script.
OPTION (MAXDOP 1)
I have a sproc that does not compile in sql compare that is perfectly valid in SQL 2008. It uses this code following a query:
OPTION (MAXDOP 1)
Is this a problem and are there any workarounds?
Snippet keywords/variables
Are there other snippet keywords like $CURSOR$
I'd be interested in ones like $DATE$ and probably some others...