How can we help you today? How can we help you today?
m.vanderwilt

Activity overview

Latest activity by m.vanderwilt

Commandline Argument: sqlcompare /argFile:"TestArgsFile.xml" TestArgsFile: <?xml version="1.0"?> <commandline> <sourcecontrol1></sourcecontrol1> <revision1>HEAD</revision1> <server2>s2L</server2> <database2>d2</database2> <username2>u2</username2> <password2> p2 </password2> <scriptsfolderxml>SourceScriptsArgs.sfx</scriptsfolderxml> <mfx>SourceMigrationScriptsArgs.mfx</mfx> <scriptFile>c:\temp\TestBuild\build.sql</scriptFile> <options>none</options> <include>Assembly</include> <include>AsymmetricKey</include> <include>Certificate</include> <include>Contract</include> <include>DdlTrigger</include> <include>EventNotification</include> <include>FullTextCatalog</include> <include>FullTextStoplist</include> <include>Function</include> <include>MessageType</include> <include>PartitionFunction</include> <include>Queue</include> <include>Role</include> <include>Route</include> <include>Rule</include> <include>Schema</include> <include>Service</include> <include>ServiceBinding</include> <include>StoredProcedure</include> <include>SymmetricKey</include> <include>Synonym</include> <include>Table</include> <include>User</include> <include>UserDefinedType</include> <include>View</include> <include>XmlSchemaCollection</include> <!-- Exclude because of SQL Compare + SQL 2012 function bug --> <!-- <exclude>View:\[Dts\]\.\[vw_Block_Job_Process\]</exclude> <exclude>View:\[Dts\]\.\[vw_Job_Failure_Info\]</exclude> <exclude>View:\[Dts\]\.\[vw_Job_Status\]</exclude> <exclude>View:\[Dts\]\.\[vw_Process_SwitchTable_Info\]</exclude> <exclude>StoredProcedure:\[System\]\.\[usp_SetSwitchTrigger\]</exclude> <exclude>StoredProcedure:\[Dts\]\.\[usp_GetJobStep\]</exclude> <exclude>StoredProcedure:\[Dts\]\.\[usp_SetJobStepStart\]</exclude> <exclude>StoredProcedure:.*\]\.\[usp_GetJobInfo.*</exclude> <exclude>StoredProcedure:\[Dts\]\.\[usp_GetPackage]</exclude> <exclude>StoredProcedure:\[Dts\]\.\[usp_StartFirstAvailableJobStep]</exclude> <exclude>StoredProcedure:\[System\]\.\[usp_GetDataChangeDate]</exclude> <exclude>StoredProcedure:\[System\]\.\[usp_CheckRelation]</exclude> <exclude>StoredProcedure:\[System\]\.\[usp_FireSwitchTriggers]</exclude> <exclude>StoredProcedure:\[System\]\.\[usp_SwitchOutPartition]</exclude> <exclude>StoredProcedure:\[System\]\.\[usp_SwitchInPartition]</exclude> <exclude>StoredProcedure:\[System\]\.\[usp_CheckConsistencyOfSwitchTables]</exclude> <exclude>Table:\[System\]\.\[SwitchTrigger\]</exclude> <exclude>Table:\[System\]\.\[SwitchTriggerStatus\]</exclude> <exclude>Table:\[System\]\.\[TableUsage\]</exclude> --> <!-- <exclude>Table:\[Dts\]\.\[ProcessInterference\]</exclude> --> <!-- Regex to exclude [Dts].[ProcessInterference] table --> <exclude>Table:.*\].\[_.*</exclude> <!-- Regex to exclude temp table starting with _ --> <ignoreparsererrors /> <!-- <include>FullTextCatalog</include> <include>Schema</include> <include>StoredProcedure</include> <include>View</include> <include>identical</include> <exclude>StoredProcedure</exclude> <exclude>Assembly</exclude> --> </commandline> / comments
Commandline Argument: sqlcompare /argFile:"TestArgsFile.xml" TestArgsFile: <?xml version="1.0"?> <commandline> <sourcecontrol1></sourcecontrol1> <revision1>HEAD</...
0 votes
Error in creating upgrade script
I'm getting an invalid upgrade script when letting SQLCompare generate this table: Original table code in the database:CREATE TABLE [Dts].[ProcessInterference]( [ProcessCod...
2 followers 5 comments 0 votes