| copying data from table(with no constraints) to table with constraints [message #557494] |
Wed, 13 June 2012 06:42  |
 |
shreeka
Messages: 5
Registered: June 2012
|
Junior Member |
|
|
I want to create a store procedure to copy data from a source tables(which may not have any constraints defined) to a table which has primary key, foreign key and unique key constraints.
Any records which are rejected due to these constraints not being satisfied need to go another table.
Once the initial data load is done, these procedures need to be automated(through cron) to do the future incremental uploads in the same manner.
Could anyone please tell me which is the best way to approach this problem?
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
] 
Members
Search
Help
Register
Login
Home
