Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
Database disappeared after deploy another SA project

Answered Database disappeared after deploy another SA project

  • Wednesday, February 13, 2013 10:10 PM
     
     
    Sign In to Vote
    0

    Hi All,

    I have two projects in two different solution files.  When I deployed Project A, Project A database shown on the Object Explorer of SSMS, but Project B database would disappear.  When I deployed Project B, then Project B database shown on the Object Explorer of SSMS, but Project A database would disappear.  I did this several times and even restarted the server, but the same happened.  I checked the database name in the deployment section of the project property and they all have different names (Project A or Project B).  I did previously deleted Project B manually from the Object Explorer.  I am wondering if that has something to do with the database switching issue I am having.  Any help will be appreciated.  

    BI Analyst

    (It seems like every time when one project is ran, it replaced the other project. I deleted the database and ran again and same issue happened.)
    • Edited by BIAnalyst Wednesday, February 13, 2013 10:19 PM More Info
    •  
     

All Replies

  • Friday, February 15, 2013 5:53 PM
     
     Answered
    Sign In to Vote
    1

    Hi there,

    You may need to check the ID of the database.  One way to do this is to right-click on the database in SSMS & see the ID field.  Is a warning message shown during deployment?  Was the second project a copy of the first project, or did you use the same default name and then rename after creating?

    cheers,

    Andrew

    Andrew Sears, T4G Limited, http://www.performancepointing.com

    • Marked As Answer by BIAnalyst Friday, February 15, 2013 7:26 PM
    •  
     
  • Friday, February 15, 2013 6:10 PM
     
     
    Sign In to Vote
    0

    Thank you, Andrew, for your help.  Yes, your guess was correct on "Was the second project a copy of the first project, or did you use the same default name and then rename after creating?", but I forgot exactly on what had happened.

    I checked the ID in the Property window and it is the same as Project A even though the database is Project B.  Since the result was the same even after I deleted the database from SSMS before I deployed the project, the change should be made on the second project - to change the id to reflect Project B (and not A).  How can I change that?

    BI Analyst

    (Added: I changed the database id from using this tip from another site and everything is working fine now.

    If you click a little button at the top of the Solutions Explorer in Visual Studio that says 'show all files' when you roll over it, you will see a file called Something.Database. View the code of that file and you can edit an element. This will change the ID of the database on deployment.

    )

    • Edited by BIAnalyst Friday, February 15, 2013 7:29 PM Additional info
    •