Solved

Best way to copy data only from one database to another

Posted on 2013-11-25
1
294 Views
Last Modified: 2016-02-11
I've created a database copy on our development server from a live database on our production server by doing a SQL backup and restore. I've done some work on the development server copy database by adding tables, stored procedures etc. As time's gone on though, the data on the development server is quite out of date. What's the best way of refreshing the data on the development server from the live server without losing any of my new database objects? It's only the table data I want to refresh by the way. Nothing else like stored procedures etc. as I've amended of these as well as creating new ones.
0
Comment
Question by:Grffster
1 Comment
 
LVL 5

Accepted Solution

by:
Lawrence Barnes earned 500 total points
ID: 39675609
I'm handling this with a cross server merge that runs on the development server and pulls data from production in small batches (so the DBA's don't hang you.)


In the source portion of your merge you create a query that morphs the production data into your development data format (additional columns, etc.) and then you use the merge to update, add or delete.

To support the batching (from production to development) you also have a query in the target portion of your merge restricing the records to the same ones as the source.

Then I while-loop these two going from batch to batch until complete...and the DBA's let me live.
0

Featured Post

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
My client sends a request to me that they want me to load data, which will be returned by Web Service APIs, and do some transformation before importing to database. In this article, I will provide an approach to load data with Web Service Task and X…
Hi friends,  in this video  I'll show you how new windows 10 user can learn the using of windows 10. Thank you.
Learn how to create flexible layouts using relative units in CSS.  New relative units added in CSS3 include vw(viewports width), vh(viewports height), vmin(minimum of viewports height and width), and vmax (maximum of viewports height and width).

867 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now