Printable View
Hi,
I have a requirement where i have to select some data (data from 7 columns from a table) periodically i.e. every 15 mins from sql server 2005 and insert the data to a remote mysql database server.
I am thinking of Store-proc to achive this. Can anyone help me with this ?
Thanks in advance.
Couple of options:
1. create linked server to mysql then copy rows via linked server in sp, set sql job to execute.
2. build ssis package and run it in sql job.
Can you provide me any link on creating SSIS.
i don't know how to configure this.
Sql books online has details and Tutorials of ssis, this link has lot of samples: http://www.sqlis.com/.
thanks so much rmiao for the help. Using SSIs i can now connect to remote database and send over the data.
Also , as this is periodical is it possible that i check the last record sent successfully and then next time the batch runs start from next record.
Shall i use trigger ??
Don't need trigger if table has datetime coumn.
Yes , i do have datetime column in my table .
But can you suggest how can i use that in conjuction with SSIS to monitor what was the last record inserted and then start from there on.
Do i need to write a sro-proc and write the nusiness logic or is there a way with SSIS that this can be achived ?
You can run sql atatement in ssis package. SSIS will not copy data automatically by the way, you have to set sql job to run it.