copy a complete SCHEMA

Last Post 12 May 2011 06:36 AM by rm. 1 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
ogruizr
New Member
New Member

--
11 May 2011 02: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 06:36 AM
Script them on server1 then run the script on server2.
You are not authorized to post a reply.

Acceptable Use Policy