SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2012 Forums
 Other SQL Server 2012 Topics
 Merge Replication - Views, Functions and SP
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

MOMENTUM101
Starting Member

1 Posts

Posted - 12/03/2012 :  11:58:49  Show Profile  Reply with Quote
I have been trying to replicate a database for a few months using Merge replication with Web Sync. Replicating the tables is pretty straight forward. The tables are currently being replicated via the Intranet and the internet with no problem.

The problem is to replicate the views, stored procedures and Functions because the database schema is extremely complex. The snapshot process keeps failing due to the relationships between these objects. Almost all the views, Procs and functions are all referencing each other in their various TSQL codes. The relationship between these objects are so complex that after two months I don't seems to be making any process.

I have tried using @processing_order to set the processing order of these objects for the snapshot process but due to the complex relation between these objects, the snapshot is still unsuccessful.

Backup and Restore is not an option due to bandwidth and logistic reason.

The Publisher is SQL Server 2012 and the subscribers are 2005.

I will greatly appreciate any help.



Regards

MJ
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000