Error-Compare SQLServer 2008R2 Databases using SQL Compare 8

Forum for users of SQL Compare schema synchronization utility

Error-Compare SQLServer 2008R2 Databases using SQL Compare 8

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

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.
Posts: 1
Joined: Thu Nov 01, 2012 12:41 pm

Postby eddie davis » Fri Nov 02, 2012 3: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 which can be downloaded using this

Many Thanks
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
eddie davis
Posts: 1146
Joined: Wed Jun 14, 2006 2: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