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
Post a Comment