MS SQL Server - Snapshot replication

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Snapshot replication

Piotr

2005-11-30, 3:23 am

Hi,
I wish to get snapshots of MSSQL data nightly, the problem is that I
cannot use another MSSQL server, is there any easy way to get snapshot
data every night in some readable formt for Access or different SQL
server such MySQL ?

regards
Peter

MarkusB

2005-11-30, 7:23 am

You could use a DTS package to export the data to Access and schedule
the package to run every night.
Doing this with replication is not so easy, even though SQL2000 allows
non-MSSQL subscribers. I would go with DTS instead.

Markus

Piotr

2005-11-30, 7:23 am

That would be a solution thanks

Sponsored Links