Error-Compare SQLServer 2008R2 Databases using SQL Compare 8

sreejith77sreejith77 Posts: 2
edited November 2, 2012 11:15AM in SQL Compare Previous Versions
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.


  • Eddie DEddie D Posts: 1,686 Rose Gold 5
    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
    Product Support Engineer
    Redgate Software Ltd
    Email: [email protected]
Sign In or Register to comment.