Solved

Best way to copy data only from one database to another

Posted on 2013-11-25
1
297 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

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

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

Here's a requirements document template for an integration project (also known as Extract-Transform-Load or ETL) based on my development experience as an SQL Server Information Services (SSIS) developer over the years.
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

803 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