About Schema | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

About Schema

Hi all
is it same thing if I create 2 schema in sql with different tables
or create 2 separate database.
What exactly do you mean by "same thing"? —
Frank Kalis
Microsoft SQL Server MVP
Contributing Editor, Writer & Forum Moderatorhttp://www.sql-server-performance.com
when I push database in developer box to production side,
will be difficult to manager later on in production?
I mean if One database with 2 schema can do the same thing with 2 database, why people create different database?
REfer tohttp://msdn2.microsoft.com/en-us/library/ms190387.aspx fyi. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.