Re: Syncing Data to Production DB Server

I used Navicat free version many times. As you rightly said, we have to
purchase license for Data Synchroniztion.Also , I cannot able to find
Talend for Linux.
Is it works only for Windows. I find one component Talend MDM for linux.
Can it satisfy my requirements ?

Thanks

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>> 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>> 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
>
>