Re: Syncing Data to Production DB Server

Yes, sure.
I have already used it. You have to create database connections to both of
your databases. Then create a job to sync data per table as per your needs.
It should not be too hard. Once you job is created then test it for any
errors. If required you have to use data transformations. Once your test
succeed, you can deploy it to java based application server. You can get
more details about it from Talend's documentation. You can also run your job
manually whenever you add data to your demo database. It will be not too
hard.
You can also use stored functions on you demo database to send the updated
data to your main database by using dblink. When ever you update data in
demo db, you can execute these function(s) to update data in main db.

Hope that will be helpful.
Regards,

Chaitany Kulkarni

On Fri, Aug 19, 2011 at 12:37 PM, Adarsh Sharma <adarsh(dot)sharma(at)orkash(dot)com>wrote:

> Thanks CK , I configured Talend but I m not able to understand how we can
> get data synk to our DB servers.
> Any views on that.
>
> c k wrote:
>
>> You can use Talend or Navicat for syncing the data as per your needs
>> without much complexity in writing a data sync application.
>> You have to purchase license for navicat but you can talend for free and
>> it also supports many other database systems.
>>
>> Chaitanya Kulkarni
>>
>> On Fri, Aug 19, 2011 at 10:18 AM, Adarsh Sharma <adarsh(dot)sharma(at)orkash(dot)com<mailto:
>> adarsh(dot)sharma(at)orkash(dot)**com <adarsh(dot)sharma(at)orkash(dot)com>>> wrote:
>>
>> Hi Michael,
>>
>> I think you misunderstood my problem.
>> I have a demo system and the data is inserted in this system.
>>
>> Simply I want this newly inserted data to be synk to my production
>> server.
>> Taking pg_dump of cumbersome daily.
>>
>> I reserached & find some proprietary solution but I think there
>> may be other solutions too.
>>
>>
>> Thanks
>> Michael Nolan wrote:
>>
>>>
>>>
>>> On Thu, Aug 18, 2011 at 11:03 PM, Adarsh Sharma
>>> <adarsh(dot)sharma(at)orkash(dot)com <mailto:adarsh(dot)sharma(at)orkash(dot)**com<adarsh(dot)sharma(at)orkash(dot)com>>>
>>> wrote:
>>>
>>> I want a simple technique through which I update my
>>> production server easily.
>>>
>>>
>>> What I do with a similar sized database is do a pg_dumpall on the
>>> production server and
>>> restore it to the laptop. Because the production server is
>>> around 950 miles from my office, it usually takes me longer to
>>> copy the dumpall file across the Internet than it does to restore
>>> it on the laptop.
>>>
>>> I do this about twice a month.
>>>
>>> I find having a test database that is a week or two out of date
>>> doesn't affect most development work. In fact, being able to
>>> restore the test database to a known state repeatedly has come in
>>> handy for testing some scenarios. Your situation may be
>>> different. --
>>> Mike Nolan
>>>
>>
>>
>>
>