The same command line is being invoked in both cases, and both cases are using the same source and target databases (a SQL Server database and a TFS source).
On the 10.7 machines, we see the "gathering migration scripts" output as the compare executes, but the scripts to do not show up in the deployment script.
Our migration scripts are "v1 migration scripts".
The command line is part of a Powershell script:
- Code: Select all
sql_compare /Database1:FACTSInfo /Version1:Head /Database2:FACTSInfo /Server1:$sqlServer /Server2:$sqlServer /filter:$filterfile /options:IgnoreWhiteSpace,IgnoreFillFactor,AddDatabaseUseStatement /sync /scriptfile:deploy.sql /force