locked
Error Deploy01234: The target database schema provider could not be determined. Deployment cannot continue.

    質問

  • I'm getting the following error when I try to deploy my DB project:

    C:\Program Files (x86)\MSBuild\Microsoft\VisualStudio\v10.0\TeamData\Microsoft.Data.Schema.TSqlTasks.targets(120,5):
    Deploy01234: The target database schema provider could not be determined.  Deployment cannot continue.

    My environment is Visual Studio 2010 Ultimate and SqlExpress 2008.

    This worked just fine before I upgraded from VS 2008 to 2010. As far as I can tell there is no documentation on this error, so any help would be much appreciated.

    2010年6月21日 21:57

回答

  • FatCat, Deployment to a database file is not supported. You must first attach the file to a SQL instance and connect to the attached database with a standard connection string. 

    Thanks,


    Barclay Hill Program Manager Visual Studio Data Tools (DataDude, DBPro, Database Edition, Database Projects, VS Data Tools) Please mark the responses as the answer if it resolves your question/issue. http://blogs.msdn.com/bahill
    2010年6月22日 16:41
    モデレータ

すべての返信

  • This error probably means there's a problem with your connection string and VS cannot connect to the target database. Can you recheck your connection string?
    -Genevieve Orchard (SQL Server Data Tools Test Team)
    2010年6月22日 0:40
  • The connection string is:

    Data Source=localhost\sqlExpress;AttachDbFilename=c:\temp\file.mdb;Integrated Security=True;Pooling=False

    In the Connection Properties form, where this is set, the Test Connection button reports Success.

    I've verified the DB is operational in SQL Server Management Server.

    2010年6月22日 6:38
  • FatCat, Deployment to a database file is not supported. You must first attach the file to a SQL instance and connect to the attached database with a standard connection string. 

    Thanks,


    Barclay Hill Program Manager Visual Studio Data Tools (DataDude, DBPro, Database Edition, Database Projects, VS Data Tools) Please mark the responses as the answer if it resolves your question/issue. http://blogs.msdn.com/bahill
    2010年6月22日 16:41
    モデレータ
  • Are there any BKMs on running DB unit tests from a TFS build server?  My first though was to just use an MDF and then deploy the DB project to it using the built-in support, but the fact that you can't deploy to a database file kind of cramps my style.
    2010年7月8日 22:38
  • jvrobert,

    If you are using a Database Project then you should use the database unit test configuration to drive deployment of the database from TFS Build.  If you are not using Database Unit Tests, you can also deploy the database project via the workflow or TFSBuild project.

    Thanks,


    Barclay Hill Program Manager Visual Studio Data Tools (DataDude, DBPro, Database Edition, Database Projects, VS Data Tools) Please mark the responses as the answer if it resolves your question/issue. http://blogs.msdn.com/bahill
    2010年7月9日 20:42
    モデレータ
  • You will get same error if you try to deploy your database to SQL Azure. I don't know what the problem is exactly but I hope that MS will fix it soon.
    With best regards,
    Gunnar Peipman
     
    Also visit my ASP.NET and SharePoint blog!
    2010年12月4日 20:44
  • You will get same error if you try to deploy your database to SQL Azure. I don't know what the problem is exactly but I hope that MS will fix it soon.
    With best regards,
    Gunnar Peipman
     
    Also visit my ASP.NET and SharePoint blog!
    Is Database Project deployment to SQL Azure still not supported ???
    -- Jignesh Patel
    2011年3月9日 1:19
  • Microsoft, are you out there? What's the story with VSDBCMD to Azure? I am also getting the "The target database schema provider could not be determined.  Deployment cannot continue." error.
    2011年3月23日 21:30
  • I am getting the same error when i tried to deploy the database schema from my local machine to a remote server. I am able to deploy in the local server with no issues but i get this error The target database schema provider could not be determined.  Deployment cannot continue." error when i try to deploy to a remote named instance. I would love to see the way to resolve this issue.

    2011年8月22日 13:31
  • A.Chapagai,

    What version of SQL is this remote server?  Only SQL 2005, 2008 and 2008 R2 are supported.

    Thanks,


    Thanks, Barclay Hill Sr. Program Manager, SQL Server – DMG (Juneau) | Microsoft Corporation http://blogs.msdn.com/bahill Please mark the responses as the answer if it resolves your question/issue.
    2011年8月22日 15:30
    モデレータ
  • SQL Server 2008 R2 is the remote SQL Server instance.  
    2011年8月22日 16:01
  • Then you must be running the 2008 version of the tools.  VS 2010 supports 2008 R2.
    Thanks, Barclay Hill Sr. Program Manager, SQL Server – DMG (Juneau) | Microsoft Corporation http://blogs.msdn.com/bahill Please mark the responses as the answer if it resolves your question/issue.
    2011年8月22日 16:08
    モデレータ
  • You meant my local machine has the 2008 version tools or the remote server? I have 2008 R2 tools in my machine. Remote machine i have to check.

     

     

    2011年8月22日 17:18
  • No, sorry, I meant the version of Visual Studio you are running.
    Thanks, Barclay Hill Sr. Program Manager, SQL Server – DMG (Juneau) | Microsoft Corporation http://blogs.msdn.com/bahill Please mark the responses as the answer if it resolves your question/issue.
    2011年8月22日 17:19
    モデレータ
  • But why would it run without issues  when i do the deployment on my machine though even if i have versions of Visual studio ? And why not to the remote server?  I am confused.

    2011年8月22日 17:34
  • Double check the version of the remote server.  Connect to it and issue SELECT @@VERSION and see what it returns.
    Thanks, Barclay Hill Sr. Program Manager, SQL Server – DMG (Juneau) | Microsoft Corporation http://blogs.msdn.com/bahill Please mark the responses as the answer if it resolves your question/issue.
    2011年8月22日 18:05
    モデレータ
  • is any update for this?

    I met similar issue: we want to deploy current db projects(2008 version) to sql server 2012 instance. it got same error as yours?

    any guys can provide some help? is any tool to convert old project for denali? or other solution for deployment?

    thanks a lot

    2012年2月24日 8:27
  • You will have to convert 2008 db project to 2012 DB Project using "Sql Server Data Tools, Database Projects"

    There are major changes/features for db development in Sql Server 2012.

    Db project has now been moved to sql server team and is now a part of "Sql Server Data Tools, Database Projects".

    Below MSDN links should give you additional details:

    Overview http://msdn.microsoft.com/en-us/library/hh272686(v=vs.103).aspx

    Installer http://msdn.microsoft.com/en-us/library/hh500335(v=vs.103).aspx

    Hope this helps,


    -- Jignesh Patel


    2012年2月24日 15:54