SQL Server Performance Forum – Threads Archive

2000 to 2005 schema issue

hi i am new to SQL 2005. we have a existing database on 2000 and converted to 2005.
in 2005 databases the objects are owned by the individual users. i have been assigned to prepare a plan how to make objects owned by schema rather than user.
Also an other question… i know how the db schema works in oracle.. how different it is from SQL 2005.
i welcome your suggestions. thanks

http://msdn2.microsoft.com/en-us/library/ms190387.aspx
you can create whatever schemas you need to cover the database’s objects and assign ownership of each schema only to the users or roles that require it to do their job.
Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing.

thanks satya
Does anyone know what different between db schema in 2005 and in schema in oracle database.

Are you talking about users(schema) in Oracle? Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing.

yes that is right. i have been doing oracle dba for a while and concept of user schema in oracle looks equivalent to db schema in 2005 but i am not sure. By concept database objects are owned by the schema instead of users.

schema is same oracle concepts. —————————————-
Contributing Editor, Writer & Forums Moderator
http://www.SQL-Server-Performance.Com Visit my Blog at
http://dineshasanka.spaces.live.com/

The User schema in Oracle is applicable in SQL 2005 schema values. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing.

]]>