Issue SELECT and INSERT statements to copy data from the source database tables to the destination DB tables from the arsystem.dbo schema to the arsystem91.dbo schema, as shown in the following example:
Insert into arsystem91.dbo .T1697 (select * from arsystem.dbo.T1697);
Insert into arsystem91.dbo .B1697 (select * from arsystem.dbo.B1697);
Insert into arsystem91.dbo .H1697 (select * from arsystem.dbo.H1697);If the column names are required for the SELECT and INSERT statements, then add them in the following format. For example, if the destination table has more columns (fields) than the source table, use the columns from the source table to map the values because it is recommended to map values for columns that exist in the source only.
Insert into arsystem91.dbo .T1697 (C1,C2,C3,C4,C5…….) select C1,C2,C3,C4,C5……. from arsystem.dbo.T1697)
