Page 1 of 1
convert datbase
Posted:
Fri Nov 03, 2006 8:32 am
by piyush
Hello sir
How can i move data from mysql to sql server.
thanks
Posted:
Fri Nov 03, 2006 3:42 pm
by mflorell
Why on earth would you want to do that?
What data specifically?
Posted:
Sat Nov 04, 2006 1:37 am
by 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
Posted:
Sat Nov 04, 2006 6:00 pm
by 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,
Posted:
Tue Nov 07, 2006 7:19 am
by 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
Posted:
Tue Nov 07, 2006 1:09 pm
by 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