What are the challenges you face when working across database platforms? Take the survey
Options

SQL Compare 8 cannot map views WITH XMLNAMESPACES

deltafsdeltafs Posts: 5 Bronze 1
edited June 27, 2011 2:47PM in SQL Compare Previous Versions
I am comparing two databases using SQL Compare 8.

We have one view using the following (valid) SQL syntax:
WITH XMLNAMESPACES ( 'http://www.govtalk.gov.uk/CM/envelope' AS ns, 'http://www.govtalk.gov.uk/CM/errorresponse'
    AS ns1 )
SELECT  gw_PK as gw_PK_int ,
...

SQL compare is failing with the following error:

unexpected token:
["http://www.govtalk.gov.uk/CM/envelope",<979>,line=32,col=61]
[char=447]

The settings for the compare are:

Decrypt objects

Ignore:

Whitespace
Fill factor
Filegroups
User properties
WITH element order
Database and server name

Which are the RedGate Defaults.

The problem ONLY occurs when opening SQL Compare and running the compare directly from the default project that opens initially.

If we close the default project and goto File > New Project and use the SAME settings the comparison works!

This is really an FYI as we have a workaround by using the New Project option it just seems odd that the default project fails with the same settings. It may also not be an issue with the new SQL Compare 9.

Comments

  • Options
    Thanks for contacting Red Gate.

    The error is unfortunately quite vague, but it does look like it might be a bug, and may quite likely have been fixed in v9.

    Would you be able to download a trial version of v9 to see if it helps?

    I will email you a trial key for this, you need to deactivate SQL Compare 8, download and install a trial copy of SQL Compare 9, then reactivate using the trial code.

    Thanks

    Siân Williams
    Red Gate Software
    Tel: 0800 169 7433
    sian.williams@red-gate.com
Sign In or Register to comment.