ssdt - Manage Visual studio 2012 Database project for a specific schema, not entire database? -



ssdt - Manage Visual studio 2012 Database project for a specific schema, not entire database? -

in database, there schema each module. each schema has several objects(tables,views..). ex: school database. has 3 modules students, staff , training , respective schema's students schema, staff schema, training schema.none of them managed through database project

student.table1 staff.table1 training.table1 training.table2

now there new module certification, , create new schema called certification , manage through database project. since, have no command on other schema's ignore them in database project want create , manage certification.

i did research find concepts partisan schema & composite schema in vs 2010. seems obsolete vs2012 database project.can guide me how accomplish this?

in database project, create 'certification' schema , of objects (tables, views, etc.) schema. when publish project, create sure set these options follows:

disable "always re-create database" disable "drop objects in target not in project"

disabling options ensure objects in other schemas not deleted.

ssdt database-project

Comments

Popular posts from this blog

assembly - What is the addressing mode for ld, add, and rjmp instructions? -

vowpalwabbit - Interpreting Vowpal Wabbit results: Why are some lines appended by "h"? -

Is there a way to convert an HTML page styled with Bootstrap CSS into email-compatible html? -