Bug? Command-Line and Migration Scripts
CowboyDba
Posts: 2
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
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. :?
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
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. :?
