RE: CPYF on SQL Server

["Pat Landrum" <PLandrum@xxxxxxxxxxxxxxxxxxxxxxx>]

Look into Replication Services in MS SQL Server.

Regards,
Pat Landrum
Senior Programmer/Analyst
Hanover County School Board
200 Berkley Street - Ashland, VA.  23005
Phone: 804-365-4658  Email: plandrum@xxxxxxx 

 

Notice:  This message or any accompanying documents may contain confidential or privileged information of Hanover County Public Schools. If you are not the intended recipient, disclosure, copying or distribution is strictly prohibited by state and federal law. If you received this message in error, please notify the sender as soon as possible.

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Adam West
Sent: Monday, August 03, 2009 3:31 PM
To: Midrange Systems Technical Discussion
Subject: CPYF on SQL Server

On the AS/400, you can copy from one library to another, be it programs, sources, data files,etc.
 
On SQL server, I liken Libraries to Databases. I have not seen a way to Copy objects between databases. Thus, If I am say creating a modifications database, to re-create a table I have, I can create said table, but I have to re-enter the actual data. Unless there is some way to copy like on the 400. You could put a '3' in front of the member and copy it, or use a CL command.