Hi,
could you give me an step-by-step example how to do replication between
MSDE2000's ?
I have 50 tables, each table has an ID GUID primary key column.
thanks.
SRINGER,
you can't use the GUIswith MSDE (not legally) so you'll have to use SQLDMO.
Have a look on www.replicationanswers.com where I have put some code in the
scripts section to set up publishers and subscribers.
Rgds,
Paul Ibison
[vbcol=seagreen]
|||Paul,
What did you mean that you can't use GUIDs with MSDE? We had planned to use
ID columns that implemented the UniqueIdentifier datatype and used the
NEWID() function to put in a GUID. We want to use these instead of the
AutoIdentity columns since they are usch a headache in merge replication.
Tommy
"Paul Ibison" wrote:
> SáRINGER,
> you can't use the GUIswith MSDE (not legally) so you'll have to use SQLDMO.
> Have a look on www.replicationanswers.com where I have put some code in the
> scripts section to set up publishers and subscribers.
> Rgds,
> Paul Ibison
>
>
|||I'm an idiot. I saw that you said GUIs and I am assuming you meant using EM
instead of the command line. Nevermind! Doh!
Tommy
"Paul Ibison" wrote:
> SáRINGER,
> you can't use the GUIswith MSDE (not legally) so you'll have to use SQLDMO.
> Have a look on www.replicationanswers.com where I have put some code in the
> scripts section to set up publishers and subscribers.
> Rgds,
> Paul Ibison
>
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment