Replicate MSsql db (Microsoft sql server) to MYsql server (linux MYsql).

I have a widows 2008 server running MSsql server with a database i need replicated to a linux MYsql server.

I really only need one table of the DB replicated (maybe 2 or 3 tables, but not the entire DB, ideally). The replications needs to be read-only so that no data can be written to or modified on the MSsql server.

Ideally i would like the ability to leave out certain columns of the table from the replication. (if this is not possible or very complicated to implement, than its ok if the entire table must be replicated)

The source (MSsql server) and destination server (MYsql server) are already able to connect to each other via a secure VPN.

I have done some research on SymmetricDS and it seems that maybe an option to accomplish my goal, so im open to using that as a solution. ( [url removed, login to view] )

I have two Virtual Machines setup (one windows, one linux) with the exact same OSs and SQL Server versions, and the exact DB in place so that the replication solution can be tested/setup , prior to being implemented on the "live" servers.

Thank you

Skills: PHP, Software Architecture

See more: sql server open source, research microsoft, open source sql, sql server or, sql server c# 2008, Open VPN , mysql mssql, mysql and sql, mssql, mssql mysql, MICROSOFT SQL SERVER, database microsoft sql, c# MSSQL, connect database using php vpn, replicate mysql windows server, php replicate, sql maybe, connect windows server 2008 vpn, 2008 connect server, sql server 2008 windows server 2008 can connect

About the Employer:
( 0 reviews ) United States

Project ID: #7019502

18 freelancers are bidding on average $133 for this job


A proposal has not yet been provided

$121 USD in 3 days
(197 Reviews)

Hello Sir, i have been working on SymmetricDS tool to sync database between my postgres and mysql db so i'm sure can apply it with your case. Please consider and have a chat on details. Thanks. THANH

$155 USD in 2 days
(41 Reviews)

Hello Hiring manager, Greetings from Evidcomm!!! We have gone through your requirements and would be pleased to work on. We have already done this kind of work in past and surely we will get finished this project More

$175 USD in 4 days
(61 Reviews)

Hi, Thank you for posting your requirement. My name is Inderjeet and own a small 4 member IT services firm based at Chandigarh,India. We have been into IT since 1994 (MS-DOS based desktop software), into Web-apps s More

$277 USD in 4 days
(9 Reviews)

A proposal has not yet been provided

$222 USD in 5 days
(13 Reviews)

Hi, I'm a senior Web/Javascript/PHP developer with many years of rich experiences. I'm interested in your project. I will do a perfact work for you. Please check my porfolio and work history for more details about me. More

$100 USD in 3 days
(7 Reviews)

Hi, I am DB developer with PHP experience. I propose to work with you to sync your data from ms sql to mysql From proposal, it is not clear 1. what is the expected data volume 2. expected frequency of sync t More

$122 USD in 3 days
(3 Reviews)

SQL server DBA for 4+ years of experience, expert in data migration projects Award winning SQL SERVER DBA. i'm aware of such issues.. I'd be glad if I could help you

$139 USD in 10 days
(1 Review)

A proposal has not yet been provided

$155 USD in 3 days
(6 Reviews)

Hello! Can do this task right now for you, it's no so diffucult at all. First of all - I'm full time freelance programmer with 10 years experience, working on local freelance sites (such as [login to view URL] and [login to view URL]) More

$88 USD in 1 day
(9 Reviews)

Hello, I am very interested in doing this project. Help me increase my portfolio. Call me in chat to us to [login to view URL]

$70 USD in 2 days
(2 Reviews)

A proposal has not yet been provided

$155 USD in 3 days
(2 Reviews)

I already do this with an Oracle DB and MySQL with SymmetricDS. So I got the experience to make this happen.

$144 USD in 3 days
(1 Review)

Hi there, I am sure that I can easily do the task for you. The only time constraint is the size of the database table. For removing the table columns, it's a simple command (nothing complicated really ^_^ ). Feel free More

$45 USD in 1 day
(1 Review)

Dear Prospect Hiring Manager. Thank you for giving me a chance to bid on your project. i am a serious bidder here and i have already worked on a similar project before and can deliver as u have mentioned I have More

$155 USD in 3 days
(2 Reviews)

Configure SSRS to publish data to mysql database in a transactional way (push replication) All updates, inserts, delete will be transfered to mysql database.

$130 USD in 2 days
(0 Reviews)

Hello Sir/Madam, I have carefully read your project specifications. I understand that you need to work with an SQL expert to replicate a windows 2008 server running on MsSQL server with a database to a linux MySQL s More

$74 USD in 2 days
(0 Reviews)

I am new here on freelancer but I am a well experienced in Translation+content writing English/Hindi/Urdu + Ms-excel + Technical writing While on the one hand 99% grammatical efficiency is guaranteed, effective tec More

$60 USD in 2 days
(1 Review)