<div>
This almost always requires custom code, as each combination will have complex indexing (SQL side) which must be normalize going to simple indexing (no-SQL side).
</div>


<div>
how about ETL and replication server like oracle goldengate, sybase replication serer ?
</div>


<div>
Same answer. You're moving from complex SQL indexing to simple non-SQL indexing, hashed lookups.<br />
<br />
Each of these types of moves tend to be unique in their design.
</div>


<div>
so can't do much on this ! no tools for it, right?
</div>


<div>
No tools for this. You'd write custom tools designed like this.<br />
<br />
1) Open connections to database + no-SQL store.<br />
<br />
2) Generate your custom SQL SELECT calls.<br />
<br />
3) Convert retrieved data into one or more no-SQL writes.<br />
<br />
4) Do all your writes.<br />
<br />
5) Rinse + repeat for all SQL data tables.<br />
<br />
6) Close all your connections.<br />
<br />
When I have a client requesting this type of work, I just use PERL to quickly whip up a one-time, throw-away script.
</div>


<div>
I write PERL code pretty much every day, for projects + command line tools I use with my private hosting clients.<br />
<br />
I've been using PERL since... 1994, so I'm guessing I qualify as a PERL programmer.<br />
<br />
I only work on code for sites I host though + I'm very expensive.<br />
<br />
Likely your best bet is to open an EE Gig + someone can assist you with your project.
</div>


<div>
&quot;I only work on code for sites I host though + I'm very expensive.&quot;<br />
<br />
ahahha, a lot of people here say the same thing.<br />
<br />
other than PERL, &nbsp;c# can do that too ?
</div>


<div>
All languages are just languages. So any language will work.<br />
<br />
That said, if I had a client suggest c# I'd try to contain my laughter... probably couldn't...<br />
<br />
I'd figure 10x to 100x the time for c# instead of PERL.<br />
<br />
Maybe longer, as your first step will be getting c# to actually work under Linux... as I'm hoping you're using Linux for your project.<br />
<br />
If you're imagining Microsoft as your target OS... whew... add 10x to every minor daily task.<br />
<br />
You're going to require a massive budget for your project is you're using non-Linux based solution.<br />
<br />
<a href="https://LaunchSpeedHosting.com" rel="ugc"><u>https://LaunchSpeedHosting<wbr />.com</u></a> covers the <a href="https://en.wikipedia.org/wiki/LAMP_(software_bundle)" rel="ugc"><u>LAMP Stack</u></a> code versions my team currently uses for projects.<br />
<br />
I always use Ubuntu for host + container OS, then run LXD at the machine level, where sites/projects all live in their own LXD containers.<br />
<br />
You may find this helpful also, a you can clone a production container into a dev container in a few seconds.<br />
<br />
This also allows you to deploy a dev site as a production site in roughly 30 seconds.
</div>


<div>
&quot;Maybe longer, as your first step will be getting c# to actually work under Linux... as I'm hoping you're using Linux for your project.&quot;<br />
<br />
excellent &nbsp;!<br />
<br />
but I heard that Tungsten replicator 3.0 can replicate from MySQL / oracle to NoSQL like Hadoop, right? it seems nearly real time, right?
</div>


<div>
&quot;<br />
v<a href="https://mariadb.com/kb/en/library/full-text-index-overview/" rel="ugc">https://mariadb.com/kb/en/library/full-text-index-overview/</a> covers details of how this works.<br />
&quot;<br />
oh, by using MariaDB ?<br />
you mean Maria DB can do a lot in this area? <br />
<br />
<br />
&quot;Based on your questions, likely best if you hire someone to assist you with your project.&quot;<br />
you mean Database developer ?
</div>


<div>
<div class="content wysiwyg-content">
hi,<br />
<br />
any &nbsp;tools/idea you all use to synchronization between traditional RDMS and NoSQL in MS SQL and maria DB and noSQL?
</div>
</div>


hi,

any  tools/idea you all use to synchronization between traditional RDMS and NoSQL in MS SQL and maria DB and noSQL?

database synchronization between traditional RDMS and NoSQL

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Databases

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.

MySQL Server

A NoSQL database provides a mechanism for storage and retrieval of data which is modeled in means other than the tabular relations used in relational databases. Motivations for this approach include: simplicity of design, simpler "horizontal" scaling to clusters of machines and finer control over availability. The data structures used by NoSQL databases (e.g. key-value, wide column, graph, or document) are specified from those used by default in relational databases, making some operations faster in NoSQL. Sometimes the data structures used by NoSQL databases are also viewed as "more flexible" than relational database tables.

NoSQL Databases

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.