SQL Replication question\advise...
SQL Replication question\advise...
SQL Replication question\advise...
SQL Replication question\advise...
SQL Replication question\advise...
SQL Replication question\advise... SQL Replication question\advise... SQL Replication question\advise... SQL Replication question\advise... SQL Replication question\advise... SQL Replication question\advise... SQL Replication question\advise... SQL Replication question\advise...
SQL Replication question\advise... SQL Replication question\advise...
SQL Replication question\advise...
Go Back  Xtreme Visual Basic Talk > > > SQL Replication question\advise...


Reply
 
Thread Tools Display Modes
  #1  
Old 07-21-2014, 07:30 AM
lidds lidds is offline
Centurion
 
Join Date: May 2004
Posts: 100
Default SQL Replication question\advise...


I have set-up SQL Replication on a number of tables, these tables contain information that is required to run my application. The replication works perfectly, I am using Snapshot publication on these tables as the data is only modified in one location. The problem that I have is I have noticed that when the data is synchronised it seems to completely drop and rebuild the tables at each SQL subscription location. The problem that I have is if a users tries to launch my application at the same time that the replication process is happening, my application errors as it cannot even find the SQL table that the stored procedure should be using as the replication process has dropped it and is currently rebuilding.

How can I get around this? Am I doing something wrong, or should I be using a different replication method?

Any help and advise would be really appreciated.

Thanks

Simon
Reply With Quote
  #2  
Old 07-21-2014, 07:34 AM
PlausiblyDamp's Avatar
PlausiblyDampSQL Replication question\advise... PlausiblyDamp is offline
Ultimate Contributor

Forum Leader
* Expert *
 
Join Date: Nov 2003
Location: Newport, Wales
Posts: 2,058
Default

That is what snapshot replication does, it synchronises the data by completely replacing the data on the destination server. Transactional replication might be more suitable as it will only send updates to the destination rather than the entire tabl every time.
__________________
Intellectuals solve problems; geniuses prevent them.
-- Albert Einstein

Posting Guidelines Forum Rules Use the code tags
Reply With Quote
  #3  
Old 07-21-2014, 08:44 AM
lidds lidds is offline
Centurion
 
Join Date: May 2004
Posts: 100
Default

PlaisiblyDamp,

Thank you for the advise I will look at this.

Just one quick question, I am new to SQL replication, so ignore the ignorance. If I use Transactional replication, and not Snapshot replication, I assume that means that I do not have to go through the process of setting up a shared directory on my server for snapshots or configuring a distribution server e.g. Right clicking on the Replication object and select Configure Distribution Wizard etc.

Thanks for you help, really grateful

Simon
Reply With Quote
  #4  
Old 07-21-2014, 10:59 AM
PlausiblyDamp's Avatar
PlausiblyDampSQL Replication question\advise... PlausiblyDamp is offline
Ultimate Contributor

Forum Leader
* Expert *
 
Join Date: Nov 2003
Location: Newport, Wales
Posts: 2,058
Default

Transactional replication will still use snapshots to get remote servers to a known state when initially setting up the replication and again if problems cause a server to get too far out of sync for transactions to work, IIRC it will still use the same folder / share concept to transfer the transactions as well.
__________________
Intellectuals solve problems; geniuses prevent them.
-- Albert Einstein

Posting Guidelines Forum Rules Use the code tags
Reply With Quote
  #5  
Old 07-21-2014, 11:18 AM
lidds lidds is offline
Centurion
 
Join Date: May 2004
Posts: 100
Default

Thanks for clarifying, you have been a big help.

Simon
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Forum Jump

Advertisement:





Free Publications
The ASP.NET 2.0 Anthology
101 Essential Tips, Tricks & Hacks - Free 156 Page Preview. Learn the most practical features and best approaches for ASP.NET.
subscribe
Programmers Heaven C# School Book -Free 338 Page eBook
The Programmers Heaven C# School book covers the .NET framework and the C# language.
subscribe
Build Your Own ASP.NET 3.5 Web Site Using C# & VB, 3rd Edition - Free 219 Page Preview!
This comprehensive step-by-step guide will help get your database-driven ASP.NET web site up and running in no time..
subscribe
SQL Replication question\advise...
SQL Replication question\advise...
SQL Replication question\advise... SQL Replication question\advise...
SQL Replication question\advise...
SQL Replication question\advise...
SQL Replication question\advise... SQL Replication question\advise... SQL Replication question\advise... SQL Replication question\advise... SQL Replication question\advise... SQL Replication question\advise... SQL Replication question\advise...
SQL Replication question\advise...
SQL Replication question\advise...
 
SQL Replication question\advise...
SQL Replication question\advise...
 
-->