PDA

View Full Version : auto get data from MS SQL server n insert into mysql database? Urgent



cstan
09-18-2006, 03:02 PM
the problem now for me is i need get data from MS SQL server everyday for daily data and insert into mysql database.

Isnt possible to create a script to auto this process?? how can it do it?
impossible to done it manually rite? everyday must be done it....

pls help me.....

thanks

codeexploiter
09-20-2006, 01:39 PM
Yes it can be done via a script, you just need to load the script it will read the data from your MS SQLServer database and insert into a table which is in MySQL that can be used for your day to day operations.

But you haven't mentioned your scripting language preference ASP, PHP, ColdFusion, Java, etc. Without that information i think it is very difficult to comment about that.

NXArmada
09-20-2006, 02:34 PM
MySQL (http://www.mysql.com) has some GUI Tools (http://dev.mysql.com/downloads/gui-tools/5.0.html) and one of them is a MySQL Migration Toolkit 1.1 that well allow you to migrate your MS SQL database or other database to MySQL.

Kingofdhamp
05-06-2009, 06:28 AM
hi CStan,

i have read you post. I am facing the same problem. I want to get data from SQL Server and store it in variables, I am using vbscript. If you have done with this plz help me.

Waiting,
Regards,