Error-Compare SQLServer 2008R2 Databases using SQL Compare 8

Forum for users of SQL Compare schema synchronization utility

Moderators: JonathanWatts, Chris Auckland, David Atkinson

Error-Compare SQLServer 2008R2 Databases using SQL Compare 8

Postby sreejith77 » Thu Nov 01, 2012 2:37 pm

Hi,
We are getting following error when we are running SQL Compare 8 against two Databases in SQL Server 2008 R2. Will upgrading to recent version of SQL Compare resolve this one? Please let us know -

System.Exception: Failed to register databases. ---> System.Data.SqlClient.SqlException: 'PowerSum' is not a recognized built-in function name.
C:\\Builds\\171\\XGS-SDI\\SCO_Mainline\\BuildType\\TFSBuild.proj(414,5): error MSB4018: Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon.
sreejith77
 
Posts: 1
Joined: Thu Nov 01, 2012 1:41 pm

Postby eddie davis » Fri Nov 02, 2012 4:15 pm

Thank you for your forum.

I thought the 'PowerSum' is not a recognized built-in function name, was fixed in SQL Compare V7.1. can you please confirm the exact version of SQL Compare you are using?

With regards to the error, to my knowledge and experience it has not occurred in SQL Compare V10.2.

The latest version is 10.2.3.1 which can be downloaded using this
LINK.

Many Thanks
Eddie
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
E-mail: support@red-gate.com
eddie davis
 
Posts: 942
Joined: Wed Jun 14, 2006 3:47 pm
Location: Red Gate Software


Return to SQL Compare Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests