November 24, 2010 at 8:00 am
Need help from the SQL experts:
We have multiple schemas in SQL 2005 and VCenter does not support multiple schemas during a migration. I know code to change one schema owner at a time but we have over 300 tables that are requiring an ownership change. We basically need to change ownership on a bunch of custom schemas to "dbo" which is usually the default.
Thanks
November 24, 2010 at 9:42 am
I suspect I'm confused. Normally you use schema's as a mechanism of managing access. If you move all the schema's to 'dbo' you're eliminating that security setting. Won't that be a problem. Further, it's possible to have the same table name in multiple schema's and you won't be able to store those all in the same schema. What happens then?
I'm just not sure why you need to eliminate the schemas.
BTW, a suggestion, take a look at SQL Refactor from Red Gate. It can do a lot of this type of work. You might also want to take a look at this free book, Team Based Development[/url]. It has a chapter on refactoring.
----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply