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