Re: Need starting advice...

Ah no. Never ask a woman about to give birth if she wants more kids. While
I'm not a woman and not about to give birth, I've spent two years on this
book and I'm ready to do something else. ;)
If you write your book, I encourage you to put yourself in the reader's
shoes. Writers that know the technology backwards and forwards might not be
able to empathize with the reader and their state of understanding. Get
someone who does not know the concepts to review it. Write about how to
solve a problem, not how to instantiate objects and set properties.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________

"Kurt Hill" <kurthill@xxxxxxxxxxx> wrote in message
news:x94Lg.1244$MF1.43@xxxxxxxxxxxxxxxxxxxxxxxxxxxxx
I've had my share of "battles" with replication -- getting it to run
stablely, dealing with necessary permissions (rather than the general
approach of everyone is SA)... Dealing with replication over the internet
to non domain servers as well as domain servers... I have yet to find a
book that adequately addresses the "real world" where nothing is every as
nice and easy as they would have you believe ;)

Although there may be many, many lines of SQL code to call to create a
subscription, it should be mostly boilerplate, I would think -- the things
that would change are the connection string, credentials, pub name and
destination database... It seems like those 200 lines of code should be
wrapped in a component and forgotten! Wanna co-author one with me?

For now, I am taking the quick and dirty path -- a few routines to copy
data into a local Access MDF. I neet to get version 1.0 out the door in a
month or so...







William (Bill) Vaughn wrote:
Frankly, over the last 10 hours I'm beginning to think that replication
might be more trouble than it's worth. I've heard from an expert (that's
done it many times) that it can take 200 lines of code to setup SQL
Server Express to handle replication. While it has taken far less (about
50 lines) to handle most of the issues with SQL Server Everywhere, it's
still pretty fragile.

Perhaps a hand-rolled approach would be better. I need to think about it
for awhile longer before going that far, but from what I've experienced
over the last 10 days fighting with replication, I'm leaning that way.



.

Relevant Pages

  • Re: A clustering question
    ... completely synchronize the SQL application with synchronous replication. ... This will virtually mirror the SQL application on the 2 servers. ... replicated data cluster which can perform the exact task that you ...
    (microsoft.public.windows.server.clustering)
  • RE: MERGE AND TRANSACTIONAL REPLICATION SUPPORT
    ... Thank you for your suggestions including the books that will soon become ... hundreds of book when using Oracle for replication. ... We expect to have 4 servers located on 4 geographical areas. ... That will be done by 3 other SQL programmers. ...
    (microsoft.public.sqlserver.replication)
  • Re: Replication between two redundant DBs
    ... This isn't possible with SQL Replication, for some reason WSS doesn't not ... support replication.... ... you have no option to have multiple databases with app servers attached to ... SQL documentation on log shipping, basically you ship the logs to another ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: Trans Replication over VPN
    ... I need to set up Transactional replication between two SQL 2005 servers. ... If anyone knows of any articles or links that would be appreciated. ...
    (microsoft.public.sqlserver.replication)
  • Re: Upgrading 32-bit AD to 64-bit - FSMO problem
    ... Ethernet adapter PUBLIC: ... regarding EX-DC3 replication look interesting...anyway, ... Performing downstream analysis. ... These servers can't get changes from home server EX-DC1: ...
    (microsoft.public.windows.server.active_directory)
Loading