copy a complete SCHEMA

Last Post 12 May 2011 05:36 AM by rm. 1 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
ogruizr
New Member
New Member

--
11 May 2011 01:07 PM
Hi all,

I have two Servers with SQL Server 2005 like this:

SERVER1 -> DATABASE1 -> SCHEMA1, SCHEMA2, SCHEMA3

SERVER2 -> DATABASE2 -> SCHEMA1

I need to copy SCHEMA2 and all its objects from DATABASE1 to DATABASE2. What is the best way to do this?
rm
New Member
New Member

--
12 May 2011 05:36 AM
Script them on server1 then run the script on server2.


Acceptable Use Policy
---