MSDE to MSDE replication with T-SQL/sp?

How can we replicate data in one MSDE to the other MSDE without having to
pay for MSSQL2000 full version to use the sql enterprise manager?
It seems that Enterprise Manager or SQL-DMO based programs rely on
system-provided stored procedures to do replication. So why not run sp thru
osql?
Is is possible for a t-sql expert to create such an sp? I searched
Internet and found few resources about msde to msde replication.
hi,
"news.microsoft.com" <martinc@.hume-travel.com> ha scritto nel messaggio
news:u40hNYVWEHA.4092@.TK2MSFTNGP11.phx.gbl...
> How can we replicate data in one MSDE to the other MSDE without having to
> pay for MSSQL2000 full version to use the sql enterprise manager?
> It seems that Enterprise Manager or SQL-DMO based programs rely on
> system-provided stored procedures to do replication. So why not run sp
thru
> osql?
> Is is possible for a t-sql expert to create such an sp? I searched
> Internet and found few resources about msde to msde replication.
>
yep... it's not very documented, but you can even use SQL-DMO replication
ActiveX controls
this is a great article,
http://www.winnetmag.com/Article/Art...079/39079.html , but only for
SQL Server Magazine subscribers...
http://www.compman.co.uk/cgi-win/browse.exe?ref=552118 has an entire
(little) chapter about replication and SQL-DMO... this is the best book
about SQL-DMO ever released...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||With the developers edition of SQL Server you can setup replication between
test systems, then script out the the entire replication setup. The script
can then be used as a template for setting up future replications.
Jim
"news.microsoft.com" <martinc@.hume-travel.com> wrote in message
news:u40hNYVWEHA.4092@.TK2MSFTNGP11.phx.gbl...
> How can we replicate data in one MSDE to the other MSDE without having to
> pay for MSSQL2000 full version to use the sql enterprise manager?
> It seems that Enterprise Manager or SQL-DMO based programs rely on
> system-provided stored procedures to do replication. So why not run sp
thru
> osql?
> Is is possible for a t-sql expert to create such an sp? I searched
> Internet and found few resources about msde to msde replication.
>