title: Replicating MSSQL Database to MySQl Through MSSQL Replication
body: <p><strong>It is a possible of duplicate question may be</strong> but please suggest me some work around </p>
  
  <p>I got this requirement.</p>
  
  <p>I have a MSSQL Database with almost 30 Tables with millions of records.
  Now i need to take Replica of the same in MySql.</p>
  
  <p>The Solution which i am thinking are (This may contains loopholes and it may not be good) </p>
  
  <p><strong>Sol 1 :-</strong> 
     I created a linked server of MySql and by using trigger in MSSQL Tables and insert in MySQl
  For the existing records by using import wizard of workbench import the data.</p>
  
  <p><strong>Sol 2 :-</strong>
     Using <a href="http://www.symmetricds.org" rel="nofollow">SymmetricDS.</a></p>
  
  <p>What is the best way to achieve this.</p>
  
  <p>I am very new to Database Administration stuffs. Please help me in this regard.</p>
  
  <p><strong>Note :-</strong> After we replicated to MySql it should be in sync with MSSQL.</p>
  
  <p><strong>UPDATE :-</strong>
      If anyone knows as the way <code>dan b</code> said how to do it via SQL Server Replication Using ODBC please 
  give some reference.</p>
  
  <p>I tried this steps <a href="http://www.techrepublic.com/blog/how-do-i/how-do-i-set-up-replication-between-microsoft-sql-server-2000-and-mysql/" rel="nofollow">here</a>. In the second step if i click new publication under Replication SSMS i got this error</p>
  
  <pre><code>SQL Server replication requires the actual server name to make a 
  connection to the server. 
  Connections through a server alias, IP address, or any other 
  alternative name are not suppported. Specify the actual server name, 
  'USER3-PC'. (Replication.Utilities)
  </code></pre>
  
  <p>I installed SQL 2008 R2 Express. And this i tried in my local machine.</p>