April 9, 2012 at 2:08 pm
Hello, i currently have environments, a QA and a Production.
I want to automate these tasks and this is how it is currently being done, please let me know if this is possible to automate, Thanks:
1)Run some job in QA
2)Runs a select statement in QA
Now in Production:
1)Delete a table in Prod
2)Copy the rows that were produced in step 2 of QA and paste into the table that just had its rows delete in Production Step 1
3)Run delete statement for a table
4)Insert rows from the table in Step 2 of production into another table
5)Run a job
6)Run a job
Can this be done automatically? I assume the tricky part is copying the data over from QA server and paste into another server....thanks
April 9, 2012 at 2:13 pm
Hi there,
If you want to be able to do this, I would use SSIS (SQL Server Integration Services), which is purely designed for what you are trying to accomplish.
The weird part about your query is when you asked to be able to get the data from the QA environment to the Production environment... I would believe it should be the other way around, but then, it depends on your requirements.
Once you have the SSIS set up, you can schedule it within SQL Server Agent on your production box, and it should work just fine.
Hope it helps,
Cheers,
J-F
April 9, 2012 at 3:09 pm
J-F,
thanks for the info! Im very new to using SQL server, is this SSIS a feature in SQL 05 I can access or would I have to purchase that service? thanks!
April 9, 2012 at 3:11 pm
taiwuit (4/9/2012)
J-F,thanks for the info! Im very new to using SQL server, is this SSIS a feature in SQL 05 I can access or would I have to purchase that service? thanks!
Comes with it. If you did not install BIDS while installing the client tools, you will need to install it to work with SSIS.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply