February 26, 2013 at 7:16 am
I have read permissions on a production server and admin rights on a dev server. I am working on a project on the dev server and need 3 tables populated with current data from the equivalent tables on the production server. My options presented by the DBAs are; 1) Restore the dev server from production 2)Create a linked server between the two boxes and write an update query. Neither of these will work for me. Option 1 will wipe out development and option 2 is not allowed per company security policy. I was thinking maybe I could script the data for the tables I need, but I think that it is only possible to script the entire DB. Does anyone have any ideas on the best way to handle this?
February 26, 2013 at 7:58 am
Dump the three tables to a csv and import them back into your dev server?
February 26, 2013 at 8:36 am
Bcp out each table using native format, then bcp in those 3 files into dev db. It is very fast method, approx 100 000 rows per second on my old laptop.
February 26, 2013 at 9:12 am
Dare I say it, could you not use the import/export wizard?
'Only he who wanders finds new paths'
February 26, 2013 at 9:23 am
That was my initial thought but the OPs post seemed to imply that it would be frowned upon by the Establishment
February 26, 2013 at 9:41 am
Thank you all. Very helpful!
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply