Bug? Command-Line and Migration Scripts

Compares and synchronizes SQL Server databases, backups and scripts.

Moderators: JonathanWatts, Chris Auckland, David Atkinson, eddie davis, Anu Deshpande, Michelle Taylor, alice.easey, james.billings, chengvoon.tong

Bug? Command-Line and Migration Scripts

Postby CowboyDba » Thu Jun 12, 2014 3:15 pm

Using sqlCompare command line and have a migration script folder.

Unfortunately I kep geting the following error:

Error: A duplicate definition was found for the table [dbo].[People]. Ensure
that case sensitivity options are set correctly and all object creation scripts
are valid. If the problem persists, contact our support.

Command being run

Code: Select all
SQLCompare.exe /include="Identical" /include="StaticData" /scripts1="." /server2="PC1" /database2="RedGateAppCI" /synchronize /migrationsfolder=".\\Migrations" /scriptsfolderxml=".\\ScriptFolderLocation.xml" /scriptFile:"C:\\Outfile.sql" /verbose

I'm assuming i may be the case that there is a script called dbo.People in the Tables folder but also a script in the Migrations folder which creates the dbo.People table.

However the GUI appeas to pick this up and deal with it as expected. :?
Posts: 1
Joined: Thu Jun 12, 2014 3:04 pm

Return to SQL Compare 10

Who is online

Users browsing this forum: No registered users and 0 guests