SQL <-> MSDE Synch
Brian Donahue
Posts: 6,590 Bronze 1
Hi Ed,
MSDE is basically the same thing as a SQL Server, so sure, why not?
There could be issues if you try to synchronize full-text catalogs from a
full-blown SQL Server to an MSDE because MSDE doesn't support them, but
other than that, it should work just fine.
Regards,
Brian Donahue
Red Gate Technical Support
"ed" <emagin2@yahoo.com> wrote in message news:i8PTmJsBEHA.2768@server53...
> Is it possible to use SQL compare to synchronize a SQL server DB and an
MSDE
> locally stored copy of the DB?
>
> I have a .net project with users heavily dependent on large data store
which
> they will primarily use off-line. When they connect, they need to sync up
> with master SQL server.
>
> We thought we'd try using MSDE and see if there is a good synch tool that
> can help us do fast synchs.
>
> Thanks
>
>
>
MSDE is basically the same thing as a SQL Server, so sure, why not?
There could be issues if you try to synchronize full-text catalogs from a
full-blown SQL Server to an MSDE because MSDE doesn't support them, but
other than that, it should work just fine.
Regards,
Brian Donahue
Red Gate Technical Support
"ed" <emagin2@yahoo.com> wrote in message news:i8PTmJsBEHA.2768@server53...
> Is it possible to use SQL compare to synchronize a SQL server DB and an
MSDE
> locally stored copy of the DB?
>
> I have a .net project with users heavily dependent on large data store
which
> they will primarily use off-line. When they connect, they need to sync up
> with master SQL server.
>
> We thought we'd try using MSDE and see if there is a good synch tool that
> can help us do fast synchs.
>
> Thanks
>
>
>
This discussion has been closed.
