locked
'POWERSUM' is not a recognized built-in function name

    Question

  • Hi all,
    I have SQL Server 2008 and Visual Studio Team System 2008 installed. I also put the Power Tools for Visual Studio 2008. I'm able to compare databases through VS but when I use the SqlSchemaCompareTask from MSBuild I get this error.

    My question is can I compare databases with SQL server 2008 and VS 2008 through MSBuild and how?

    Any help will be appreciated

    Wednesday, September 16, 2009 1:57 PM

Answers

  • There is not a Compare Database MSBuild task in GDR.  There is VSDBCMD. With VSDBCMD you can generate a script based on the differences from a dbschema to a database and import a database model into a dbschema.
    Barclay Hill Program Manager VSTS: DB Team (DataDude, DBPro, Database Edition) Please mark the responses as answer if it resolves your question. http://blogs.msdn.com/bahill
    • Marked as answer by Dekkkart Friday, September 18, 2009 7:54 AM
    Thursday, September 17, 2009 2:34 PM

All replies

  • Dekkkart,

    POWERSUM is undocumented and depricated. See this post: http://social.msdn.microsoft.com/Forums/en-US/vstsdb/thread/ddbb7f25-2ed5-4e7e-a80e-f15726952a25

    Thanks,
    Barclay Hill Program Manager VSTS: DB Team (DataDude, DBPro, Database Edition) Please mark the responses as answer if it resolves your question. http://blogs.msdn.com/bahill
    Wednesday, September 16, 2009 5:21 PM
  • Barclay,

    Thanks for the reply. Yes I read that post, but in my case I don't have SQL Server 2005 installed, and maybe the SqlSchemaCompare task is trying to generate a script which has this POWERSUM. I'm wondering if someone managed to use the Power Tools to compare two Sql Server 2008 databases and if not with these tools how?

    And what is vsdbmc.exe?
    Wednesday, September 16, 2009 7:07 PM
  • Dekkkart,


    Sorry, I should have explained this earlier. SQL Server 2008 support was added in the GDR version of the product.  You can upgrade to this version freely from Visual Studio Database Edition 2008 SP1. There are many new features in the new version of the product. You can find more information about GDR here: http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=bb3ad767-5f69-4db9-b1c9-8f55759846ed

    One thing to note is that the powertools for 2008 do not work for GDR, but many of the features are pulled forward into GDR. 

    VSDBCMD is a command line tool included with GDR that allows you to deploy a model to script/database from the command line. Read more about it here:
    http://msdn.microsoft.com/en-us/library/dd193283.aspx
    http://blogs.msdn.com/bahill/archive/2009/02/21/deploying-your-database-project-without-vstsdb-installed.aspx

    Thanks,

    Barclay Hill Program Manager VSTS: DB Team (DataDude, DBPro, Database Edition) Please mark the responses as answer if it resolves your question. http://blogs.msdn.com/bahill
    Wednesday, September 16, 2009 11:31 PM
  • Beside what Barclay stated, that PowerSum is an undocumented function and has been removed from SQL Server 2008.

    You need to GDR release in order to have support SQL Server 2008, however the Schema Compare MSBuild task, which is part of the 2008 RTM Power Tools, is not supported incombination with the GDR release and does not support SQL Server 2008.


    GertD @ www.DBProj.com
    Thursday, September 17, 2009 1:03 AM
  • Thanks to you two, but is there a way to compare databases through MSBuild in the GDR release and how am I suppose to do it?

    Thursday, September 17, 2009 7:21 AM
  • There is not a Compare Database MSBuild task in GDR.  There is VSDBCMD. With VSDBCMD you can generate a script based on the differences from a dbschema to a database and import a database model into a dbschema.
    Barclay Hill Program Manager VSTS: DB Team (DataDude, DBPro, Database Edition) Please mark the responses as answer if it resolves your question. http://blogs.msdn.com/bahill
    • Marked as answer by Dekkkart Friday, September 18, 2009 7:54 AM
    Thursday, September 17, 2009 2:34 PM
  • And what about the data? can I use VSDBCMD to compare databases and get data differences?
    Friday, September 18, 2009 7:56 AM
  • Sorry, no.  We do not have a ready solution to run data compare as part of the build.  You can however automate data compare with DTE.  See this blog post: http://blogs.msdn.com/psirr/archive/2008/11/22/data-compare-dte-commands.aspx

    Barclay Hill Program Manager VSTS: DB Team (DataDude, DBPro, Database Edition) Please mark the responses as answer if it resolves your question. http://blogs.msdn.com/bahill
    Friday, September 18, 2009 3:51 PM