convert datbase

[piyush]

Hello sir
How can i move data from mysql to sql server.
thanks

[mflorell]

Why on earth would you want to do that?

What data specifically?

[piyush]

hello

i uses the vicidial .
i have a crm project in which sql server databased is used
so i want that after each dialing records should be updated in sql servers database according mysql batabase.

so how i can connect mysql to sql server for this

plz give detail for this.

thankyou

[gschaller]

Write a script which reads entries from mysql and write's them to sql server. After successful writing to sql server the script should save the position of the last database entry. Next run the script should look to the saved position and start work after this position,

[piyush]

thankyou for your response
but i m new in database technologies ,so can u give me the compleat idea or reference about it.
means script sample or concerted link
thankyou

[vctor]

Try googling you SQL query.

Why not port your crm project to mysql. Im sure it would not take that long to do that considering that it is SQL. And also you would need to insert additional code to vicidial if you have a separate database for the crm