Error in creating upgrade script

• 
  Are you using schema/owner mapping? Try using the default mapping and it may go away.

  Brian Donahue November 23, 2012 09:41

  - 0 +
• 
  How can i do this with the commandline edition of SQLCompare?

  m.vanderwilt November 28, 2012 04:44

  - 0 +
• 
  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>
  

  m.vanderwilt November 28, 2012 05:43

  - 0 +
• 
  The problem is, SQL Compare is treating function names like object names, surrounding them by SQL Identifiers, ie [concat]. This is definitely a bug in SQL Compare, I was just trying to identify whether it is a new or existing bug. There is an existing bug where this happens only when you attempt to map schemas. So this looks like an entirely new bug.

  Brian Donahue December 03, 2012 04:47

  - 0 +
• 
  Bummer. When will this be fixed? :-)

  m.vanderwilt December 03, 2012 15:05

  - 0 +

Add comment

Please sign in to leave a comment.