Solved

SQL Server 2008 Replication

Posted on 2011-03-08
2
341 Views
Last Modified: 2012-05-11
I'm attempting to setup replication between two different schemas within SQL Server 2008, and I'm wondering if  it is possible to run replcation with two schemas that are different, and if so what is the best replication type.
0
Comment
Question by:nitayalevette
2 Comments
 
LVL 14

Accepted Solution

by:
Daniel_PL earned 250 total points
ID: 35071928
What do you mean by saying 'different' about other schema?
You can use SSIS for that if you don't need real time or maybe by adding some triggers with SSIS making resolution 'real time' ;)
0
 
LVL 28

Assisted Solution

by:Ryan McCauley
Ryan McCauley earned 250 total points
ID: 35072068
I'd be in favor of a periodic SSIS job that moves all your data from one location ot the other. Replication (in the SQL Native Replication sense of the term) is designed for exactly copied schemas in different locations. To put it another way, replication is built to re-play your local transactions against a remote dataset so everything stays in sync - when you change the data layout at the remote location, it can no longer replay the transaction, so you can't use native replication.

To replicate from one table to another of a different layout, you'll need to either roll your own replication (SSIS or a custom SP in a SQL Agent job), or invest in a product that does that kind of thing for you (like Oracle Goldengate).
0

Featured Post

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

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

In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…
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…

828 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