Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
companionz
Yak Posting Veteran
54 Posts |
 Posted - 2009-08-21 : 06:00:57
|
| Hi,I need to transfer data from Prod database table to another table in Development. But the issue is that this table has a job which runs every 1 minute and deletes all the records from the table in prod. Now its like as if 20-50 records generates in a minute and i've to transfer around 1000 records in Dev database.. So how to go about it?I created a SSIS package for transferring data but the issue is there won't be so much records. and we can't stop the job in prod.Any suggestions.Thanks,Sourav |
|
|
YellowBug
Aged Yak Warrior
616 Posts |
Posted - 2009-08-21 : 09:15:14
|
| Maybe you can create a DELETE trigger on the Prod table.And write the records from the DELETED table in the trigger to a new table - then copy this new table to dev. |
 |
|
|
companionz
Yak Posting Veteran
54 Posts |
Posted - 2009-08-21 : 09:28:07
|
| That's not possible, its just as if i can send a script to the DBA and that should do it all. I was just thinking if i can have something like a timer, which will invoke after every minute and insert that record in a temp table and will then when some count say 1000 reach would run the SSIS package.. Is it possible ??SQL Experts please reply..Thanks,Sourav |
|
|
|
sandybhan
Starting Member
1 Post |
Posted - 2009-08-21 : 13:59:02
|
| Ya hi,Enable the log files for delete opration on this Table ..then with the help of those log file restore the data in diffrent Table you want...Sandeep Bhan |
|
|
|
YellowBug
Aged Yak Warrior
616 Posts |
Posted - 2009-08-22 : 07:05:43
|
| Can you run Profiler and capture the INSERT statements going into the production table?Then run those statements as a script in DEV.Would that work in this situation? |
|
|
|
|
|
|
Exporting data