Posts
Sort by recent activity
SQL Compare Command-Line Exit Code
I am using SQLCompare (13.4.8) within an SSIS package and invoking a project with the following command-line:SQLCompare.exe /project:"\\PathToProject\Project.scp" /sync /include:IdenticalWhen this ...
Question regarding privileges
Can someone tell me what privileges are required to deploy Oracle changes to the target database? These deploy scripts potentially include create table scripts. That's not such a big deal as the ...
Is there a way to include Temporary tables in compare?
I need to compare/sync a view in one database to scripts, and then compare/sync that script to a TABLE in a database in another environment. I was going to do a "Select * INTO ##TempTable FROM Tab...
Object Reference when comparing
I am using SQL Compare to compare a SQL database (only one table selected) to a script folder and then doing a deploy to that script folder. I am then doing a compare from that script folder again...
Ignore Foreign Keys
For the life of me I can't figure out how to ignore foreign keys when doing a compare. I've looked in the docs and tried every option I can think of and it still includes Foreign Keys, which I don...