Hi there,
Basically, i have a primary database, which is MSSQL. I want to replicate some of this data (results from a query so only certain tables/fields are replicated) every night to a mysql database.
I've had a look at mysql's MyODBC and installed that on my mssql machine, and i've had a play and it seems to work about right.
Just wondering:
a. how can i schedule mssql do do this periodically, i.e 9pm every night
b. is there any thing i should know about before i do this? The mysql database will only be dishing out data so there shouldnt be any chance of corruption.
c. is there an easier way?
Thanks.
