Create a Copy table script to copy the base data tables from XYZ Test to XYZ Production. Following tables should be included in this script: • ART_SUP_T • BATCH_DEF_T • BU_ADDRESS_T • BU_TAX_REG_T............. AND SO on upto 50 to 60 tables. The copy script should have a logging mechanism, to log the following information: • Table transferred • Number of records transferred per table (read in source, committed in destination) • Error logging The created log file should be human readable and saved as ASCII file with timestamp and *.log file extension.
For multiple tables how do i need to implement... can u provide some script.
SET ARRAY 200 SET COPYCOMMIT 1000 COPY FROM firstname.lastname@example.org - TO email@example.com- APPEND A - USING - SELECT * - FROM A
891933 wrote:On what specifically? Technical solutions to the problem?
I dint understood exactly what does it mean...
could you please elaborate on this...
for example i have Two tables in Prod ( A, B table) and two tables in Test (A, B table)Why ASCII log file? That is very primitive. Why not use a log table? Why not directly push the data from the source database to the destination database? How much new tables be handled (exist on source and not on destination)? How must changes to existing database tables be handled? How must referential data integrity be handled? What about database triggers - should triggers fire on the destination database when data from the source database is inserted? Should triggers be disabled during the sync and enabled afterwards?
Now i want to copy the data from prod to test.
with the below mentioned details like
• Table transferred
• Number of records transferred per table (read in source, committed in destination)
• Error logging
The created log file should be human readable and saved as ASCII file with timestamp and *.log file extension.