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.