Running a Compare - getting this error - 'PowerSum' . . .

Forum for users of SQL Compare schema synchronization utility

Moderators: JonathanWatts, Chris Auckland, David Atkinson

Running a Compare - getting this error - 'PowerSum' . . .

Postby breiss » Tue Feb 17, 2009 9:47 pm

Comparing to db instances one in SQL 2000 and the other in SQL 2008 with SQL2000 compatibility.

Getting the following error . . .

'PowerSum' is not a recognized built-in function name.
breiss
 
Posts: 2
Joined: Fri Feb 29, 2008 8:24 pm
Location: San Diego, CA

Postby Simon C » Wed Feb 18, 2009 11:50 am

SQL Server 2008 removed a function that SQL Compare 6.2 and below used during population. I'm afraid you need to use SQL Compare 7.0 or above to compare SS2008 databases, even in compatability mode.

Simon C
Simon C
 
Posts: 140
Joined: Tue Feb 26, 2008 4:56 pm
Location: Red Gate Software


Return to SQL Compare Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests