Red Gate forums :: View topic - Error-Compare SQLServer 2008R2 Databases using SQL Compare 8
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Compare Previous Versions
SQL Compare Previous Versions forum

Error-Compare SQLServer 2008R2 Databases using SQL Compare 8

Search in SQL Compare Previous Versions forum
Post new topic   Reply to topic
Jump to:  
Author Message
sreejith77



Joined: 01 Nov 2012
Posts: 1

PostPosted: Thu Nov 01, 2012 2:37 pm    Post subject: Error-Compare SQLServer 2008R2 Databases using SQL Compare 8 Reply with quote

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.
Back to top
View user's profile Send private message
eddie davis



Joined: 14 Jun 2006
Posts: 940
Location: Red Gate Software

PostPosted: Fri Nov 02, 2012 4:15 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group