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

    Domanda

  • 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.

    lunedì 21 giugno 2010 21:57

Risposte

  • 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
    martedì 22 giugno 2010 16:41
    Moderatore

Tutte le risposte

  • 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)
    martedì 22 giugno 2010 00: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.

    martedì 22 giugno 2010 06: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
    martedì 22 giugno 2010 16:41
    Moderatore
  • 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.
    giovedì 8 luglio 2010 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
    venerdì 9 luglio 2010 20:42
    Moderatore
  • 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!
    sabato 4 dicembre 2010 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
    mercoledì 9 marzo 2011 01: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.
    mercoledì 23 marzo 2011 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.

    lunedì 22 agosto 2011 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.
    lunedì 22 agosto 2011 15:30
    Moderatore
  • SQL Server 2008 R2 is the remote SQL Server instance.  
    lunedì 22 agosto 2011 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.
    lunedì 22 agosto 2011 16:08
    Moderatore
  • 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.

     

     

    lunedì 22 agosto 2011 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.
    lunedì 22 agosto 2011 17:19
    Moderatore
  • 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.

    lunedì 22 agosto 2011 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.
    lunedì 22 agosto 2011 18:05
    Moderatore
  • 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

    venerdì 24 febbraio 2012 08: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


    venerdì 24 febbraio 2012 15:54