Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I'm a newbie in RDBMs and I have the question regarding replication between SQL Server (Oracle in future) and NOSQL MarkLogic server (ML).

There are two servers:

  1. Machine with SQL server 2008 R2 (Standard edition)
  2. Machine with MarkLogic server.

SQL server has a lot of tables (data1, data2, ....., data200) with rows that can be changed, removed or added.

My goal is to provide replication between servers.

I need to retrieve data from SQL server and save it to ML. There is no problem with it. I can execute SQL query from ML server. But, the most important thing is tracking changes in those tables. Of course, I could retrieve all data from all tables and compare it with existing data in ML, but it is very expensive.

So, I see few ways to resolve my problem:

  1. As far as I know I can to get last modify data of each table.

SELECT modify_date FROM sys.tables WHERE name = 'data1';

ML server could to check SQL's tables every 1 or 2 minutes and retrieve data from modified tables.

  1. Create procedure that would send http-post when the data changed. I've heard that isn't good idea.

  2. Use capture data, but it isn't my way, because CD is supported by SQL server enterprise.

  3. ML server has own ODBC driver, Maybe can somehow to use it?

Are there any more ways or good practice to replicate data between SQL server 2008 R2 and other NOSQL DB (ML, MongoDB and other.)?

Thanks.

share|improve this question
2  
Replication from SQL Server to NOSQL databases is not supported. msdn.microsoft.com/en-us/library/ms151864(v=sql.105).aspx –  Kin Jul 25 '13 at 15:03
    
Yes, but I want a kind of "replication" by hands. Are there good practice? –  Andrew Orlov Jul 26 '13 at 11:04
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.