Stack Overflow
Stack Overflow

Questions tagged [sqlcompare]

SQL Compare is a database comparison and synchronization tool created by Red Gate.

44 questions
0
votes
1 answer

SQL Compare Command-line does not synchronize database

In order to automate database synchronization using the SQL Compare command line; I have created a project to compare and deploy from my local database to a database in another server. Then I create a bat file. here is my bat file: SET…
Meyssam Toluie
  • 1,061
  • 7
  • 21
0
votes
1 answer

Equivalent of /mfx in SQL Compare 12?

In previous versions of Redgate's SQL Compare it was possible to pass in a command-line parameter with the location of the migrations scripts folder thus: sqlcompare /mfx $migrationScriptsFolder However, in the latest version of SQL Compare (12)…
David Brower
  • 2,888
  • 2
  • 25
  • 31
0
votes
1 answer

Using SQLCompare to compare a project to other DBs

I'm trying to compare some project that I have in RedGate using SQLCompare. I know that using this command: sqlcompare /Project:"E:\XYZ\Project.sdc" Will compare the default DBs. I want to compare several databases with that project, I know that I…
CrazyCow89
  • 73
  • 1
  • 1
  • 3
0
votes
1 answer

How could I hide Redgate sql compare licenced serial number at console execution?

How could I hide sql compare licenced serial number at console command execution? Command: "C:\Program Files (x86)\Red Gate\SQL Compare 11\SQLCompare.exe" /project:aaa.scp" /filter:"bbb.scpf" /scriptfile:"ccc.sql" /force /report:"ddd.xml" Output…
Ozgur Kaya
  • 253
  • 2
  • 7
0
votes
1 answer

Providing default value for unmapped column in SQL Compare

Is it possible to provide a default value or a query to provide a value to an unmapped column in the target table using Redgate SQL Data Compare? To explain the scenario I have a configuration database that holds settings data for several database…
Stewart Alan
  • 1,521
  • 5
  • 23
  • 45
0
votes
1 answer

How do I go about creating a script to compare , update and match structure of two databases

I am comparing two databases using open diff which is similar to SQL Compare. I have two databases which should match in structure so as I compare I would like to construct a script such that if the one DB has a specific table that the other DB…
King Code
  • 61
  • 1
  • 3
0
votes
1 answer

SqlCompare command line remote server

I am trying to use the sqlcompare command line utility to compare a local database and a remote database but I am having difficulty doing this. I would like to specify a connection string or some way to connect to the remote server…
TheWebGuy
  • 11,429
  • 16
  • 52
  • 72
0
votes
1 answer

SQL Compare deployment scripts do not include all ALTER SCHEMA commands

I have a database that I am trying to clean up on SQL Server 2008 (not R2). Currently, all tables reside in the dbo schema. Some table names are singular, others are plural. I created a new schema, crm. I moved all of the tables from dbo to crm and…
bryangm
  • 163
  • 1
  • 3
  • 10
0
votes
2 answers

Getting identical objects to show in SQL Compare

Is there a way to get SQL Compare to output all objects, specifically stored procedures, in a database and not just those that differ?
sinrtb
  • 136
  • 1
  • 2
  • 6
0
votes
1 answer

SQLCompare SDK using more than the default options

I want to use SQLCompare as part of a project to generate a script for upgrading databases. I have a set of options that should be included when I go to register the database, but I don't know how to combine the options. I'd like to send more than…
Brian J
  • 694
  • 1
  • 21
  • 34
0
votes
1 answer

How can I remove sp_addextendedproperty from a SQL Server view script?

I am doing a comparison of my Dev and QA databases. My Dev database has a bunch of sp_addextendedproperty information, which prevents the scripts from being an exact match. I tried dropping and recreating the offending view, but the noise is still…
Tarzan
  • 4,270
  • 8
  • 50
  • 70
0
votes
1 answer

Keyboard shortcuts for Red Gate SQL Compare

In Red gate SQL compare Are there any keyboard shortcuts to move from the pane in which we have to tick, to the pane in which the actual difference is shown so that I can scroll down to look at the difference. Like if the difference is readily…
puneet
  • 769
  • 1
  • 9
  • 34
0
votes
1 answer

Redgate's SQLCompare Schema Comparison Not Removing or Adding Objects Via Command Line

I have a saved SQLCompare project which I use to synchronize my local database with another "master" database. When I run the project via the GUI, everything works fine. However when I run it via the command line, only objects that exist on both…
Todd Ropog
  • 1,133
  • 1
  • 14
  • 23
0
votes
1 answer

SQL Server 2008: If Multiple Values Set In Other Mutliple Values Set

In SQL, is there anyway to accomplish something like this? This is based off a report built in SQL Server Report Builder, where the user can specify multiple text values as a single report parameter. The query for the report grabs all of the values…
AJH
  • 365
  • 1
  • 4
  • 18
1 2
3