Closed

MSSQL to MySQL

I need either a Windows or Linux program or even a DTS package that can be ran as a scheduled task or through a cron job. I need to be able to dump parts of my MS SQL server database to a MySQL database on my webserver.

The problem is that the source (MS SQL) contains some text fields with over 8000 characters and DTS generates "query based insertion of blob values is not supported" errors.

Preferably I would be able to select the source / tables (MS SQL) and the destination / tables (MySQL) and set the time(s) the data transfer would occur. Before each table is transfered, it would first truncate the destination table before any rows are inserted.

Skills: C Programming, Linux, Perl, Python, Visual Basic

See more: job values, c# database mysql, webserver, sql mysql, rows, Mysql, mysql to sql, mysql query, mysql mssql, mysql and sql, mysql 4, mssql mysql, c++ mysql, C# MySQL, c mysql, mysql characters, mysql inserted, scheduled, table perl, perl table, query mssql, database dump, mysql tables rows, mysql source, source destination

About the Employer:
( 0 reviews ) Shelton, United States

Project ID: #5797

18 freelancers are bidding on average $342 for this job

siddhartha1

Sir, we can provide you the solution of your requirement, pls contact via pm

$500 USD in 18 days
(10 Reviews)
6.5
DougRoyer

I have written many MS and MY SQL programs. Having one convert should not be a problem.

$100 USD in 5 days
(8 Reviews)
6.1
eccentricworld

hi, we can do this in good manner. regards sri

$270 USD in 5 days
(7 Reviews)
5.4
webrains

Dear sir, We are pleased to introduce ourselves as a software development firm based in Bhubaneswar since FEB 2002. So far we have completed nearly 300 + projects. We are proud to have few the most esteemed clients in More

$499 USD in 7 days
(2 Reviews)
4.0
xenon79

Hi, if the project is still available, please send me an example (the structure of the MS sql and the MYSQL databases and a few records) and I'll make a beta version with no obligations for you. More

$170 USD in 3 days
(1 Review)
2.8
eenavin

can be done

$200 USD in 7 days
(1 Review)
2.0
sunita12

Hello, I have wide area experience in open source technology like php/c++/linux/so files/fusebox AND WINDOW based ASP,COM,DCOM,MTS,VB,VC++,.NET,Flash Please forward me your mail ID so i can forward you project proposal More

$450 USD in 15 days
(1 Review)
3.3
inavigators

We wish to introduce iNavigators as an Information Technology arm of Rungta Enterprises, a multimillion-dollar conglomerate that was conceived with a singular charter to provide quality software solutions and to cater More

$500 USD in 10 days
(0 Reviews)
0.6
gunjankvel

We are a group of professionals having more than 5 yrs [url removed, login to view] can do the work for you

$300 USD in 5 days
(0 Reviews)
0.0
ftimes

I can't work out what your platform arrangement is from the details you give but here is a solution. This can be done with php and an ODBC driver to MS SQL and PHP's own driver to MySQL. Then use PHP to migrate the d More

$500 USD in 21 days
(0 Reviews)
0.0
dhavalgs

We can provide u the solution. Please see PMB

$500 USD in 30 days
(0 Reviews)
0.0
rschipie

Hello people, I can fix this for you but have a look at the PMB.

$500 USD in 7 days
(0 Reviews)
0.0
halwasiyainfosys

Dear Sir, We have understood your requirements and can easily do the project as we are having more than 5 years of experience in IT industry and we are India's leading IT company. We offer 100% satisfaction and money More

$100 USD in 5 days
(0 Reviews)
4.0
Subbiah

Dear Sir/Madam, United Techno Solutions, based at Boston, MA is a software consulting company with expertise in database technologies and web related services. We have proved our competence in these technologies wit More

$400 USD in 15 days
(0 Reviews)
0.0
nidle

Dear Sir/Madam. We had carefully examined your project and got your idea. We can provide you EXACTLY WHAT YOU NEED!!! We had already developed a great number of projects similar to yours and have all the required skill More

$420 USD in 15 days
(1 Review)
4.6
sarabjeetkaur

We have fairly good experience in database applications on various platforms. We have our development centre in India equipped with all the necessary skill set. Please visit our website for more details at [url removed, login to view]<b>< More

$300 USD in 7 days
(0 Reviews)
0.0
bid1

we can do it.

$500 USD in 5 days
(0 Reviews)
0.0
jultom

We can do this script using VB with ODBC ( MyODBC for MySql ). We can develop a generic conversor. Regards, Jultom.

$250 USD in 15 days
(0 Reviews)
0.0
erhardsmit

Hi. I can write a windows program that can run on scheduled intervals to dump data from the mssql db and then import the data into the mysql db, truncation and any other rules you need I can incorporate in the program. More

$200 USD in 7 days
(0 Reviews)
0.0