Solved

Configure a SQL 2008 Replication job (Copy a databse and replicate to it)

Posted on 2014-04-04
1
293 Views
Last Modified: 2014-04-13
Hi There,

I want to make a copy of a SQL database and replicate data from another database to it continously.  

So lets say I have production DB, I want to copy that and replicate to it and call it DevDB.

Please advise on how to do this in SQL 2008 and any gotchas or issues in doing this.

Thanks!
0
Comment
Question by:btny
1 Comment
 
LVL 39

Accepted Solution

by:
lcohan earned 500 total points
ID: 39978495
"I want to make a copy of a SQL database"
You can use "Copy Database" task under SSMS, right click the DB you want to copy, and select the option from the "Task" menu that pops up.
http://msdn.microsoft.com/en-us/library/ms188664(v=sql.100).aspx

" replicate data from another database to it continuously. "
I suggest you setup a Transactional Replication
http://technet.microsoft.com/en-us/library/ms151706(v=sql.100).aspx
http://technet.microsoft.com/en-us/library/ms151254(v=sql.100).aspx

but if you really rally need "continuously" then see if Mirroring can serve your purpose:

http://blogs.technet.com/b/meamcs/archive/2010/12/04/sql-mirroring-amp-replication.aspx
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

In this article I will describe the Copy Database Wizard 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.
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

863 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

21 Experts available now in Live!

Get 1:1 Help Now