Drop Table
Support Forum for database administrators and web based access to important newsgroups related to databasesHi, 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
Post Follow-up to this messageYou 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
Post Follow-up to this message
Show a Printable Version
Email This Page to Someone!
Receive updates to this thread