Re: Use Replication or Not
From: Armaghan (Armaghan_at_discussions.microsoft.com)
Date: 07/21/04
- Next message: Jay Chan: "Remove all copies of the same record from merge-replicated table in multiple databases"
- Previous message: Hilary Cotter: "Re: Setting Job Thresholds in SQL Server Agent"
- In reply to: Paul Ibison: "Re: Use Replication or Not"
- Next in thread: Paul Ibison: "Re: Use Replication or Not"
- Reply: Paul Ibison: "Re: Use Replication or Not"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 21 Jul 2004 07:59:51 -0700
Hahaha! Man your doing a good job. You dont' wanna look at the database. It reminds me of the Dracula :)
Anyhow, I got another idea i wanna bounce it off you.
What if I put a whole bunch of flags in the tables to indicate new/changed records, write a DTS Package which handles all updates, inserts n stuff and then schedule it to run every set interval.
{now the trick questions}
Will this work? How reliable is the DTS job scheduling? Is this a better way to handle replication?
I really appreciate and will appreciate your help on this matter.
Thanx
"Paul Ibison" wrote:
> Armaghan,
>
> sounds horribly like some of my support work :-)
>
> In this case there is no easy solution, especially as you want to be able to
> have updatable subscribers.
>
> If you could live with RO subscribers, then transformable subscriptions or
> indexed views would be the way to go.
>
> For updatable subscribers and big schema changes, I'd recommend
> restructuring the source database and recoding the VB app. This is a big hit
> initially but longterm it is the best way to create a maintainable solution
> IMHO.
>
> Regards,
>
> Paul
>
>
>
- Next message: Jay Chan: "Remove all copies of the same record from merge-replicated table in multiple databases"
- Previous message: Hilary Cotter: "Re: Setting Job Thresholds in SQL Server Agent"
- In reply to: Paul Ibison: "Re: Use Replication or Not"
- Next in thread: Paul Ibison: "Re: Use Replication or Not"
- Reply: Paul Ibison: "Re: Use Replication or Not"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
