Search code examples
visual-studio-2012sql-server-data-tools

Change database Schema name in database project vs2012


I have a database project that currently is using "dbo" schema. I want to update the dbo to something else.

I am able to find the project setting to change the default dbo schema name, but it only works for the new added table. How can I update existing table from dbo to something else.

Please help me,


Solution

  • My questions is to changes existing schema name from dbo to something else.

    I finally find a easy way to do it.

    I used the sql schema compare in vs 2012 .

    1) change the actually database schema. 2) select the actually database as the source and and select my database project as target. 3) do a update. it will update the database project.