May 15, 2013 at 7:30 am
Hi,
I have a requirement to refresh some tables in dev from prod...and we need to do this every week...so i need to automate...
I thought of using SSIS, but never did it....if anyone did please let me know the process or your suggestions.
Thanks
May 15, 2013 at 7:56 am
Robin35 (5/15/2013)
Hi,I have a requirement to refresh some tables in dev from prod...and we need to do this every week...so i need to automate...
I thought of using SSIS, but never did it....if anyone did please let me know the process or your suggestions.
Thanks
When you mean refresh, you mean drop and recreate the whole table? Are you keeping some records, if that's the case, how many? ... how big the table is or will be? ...
SSIS maybe faster but also more difficult to maintain.
Depending of how many records and where those two instances are, you may consider bcp as well. You export via bcp, then import via bcp. You can put that logic inside a job and there you go, you have it scheduled.
If you need to wipe out the whole table, you can drop indexes prior import, truncate, and re-import. Take a look on dependencies though, like constraints or identity keys. That may be an issue when refreshing the table, even with SSIS.
If you go that route, here's a good link or article for bcp: https://www.simple-talk.com/sql/database-administration/working-with-the-bcp-command-line-utility/
May 15, 2013 at 9:51 am
Do you intend to move all objects AND all data?
Do you have constraints on having prod data in DEV? (security etc.)
You may need processes that obfuscate data that cannot be viewed by developers.
May 15, 2013 at 11:39 am
Thanks for the response...
Never mind our requirement has changed and we are going to do full db restore...
Thanks again
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply