Wednesday, February 13, 2013 10:10 PM
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
Friday, February 15, 2013 5:53 PM
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?
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
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?
(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