Re: [GENERAL] Syncing Data to Production DB Server

2011-08-19 Thread c k
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

[GENERAL] Syncing Data to Production DB Server

2011-08-18 Thread Adarsh Sharma
Dear All, I want some views on the below requirements : 1. I have a Postgres DB server with 25 GB database. It has more than 110 tables. I am using Postgresql 8.3 on a CentOs. 2. I have another system laptop that contains the same database but it is for testing purposes. What I want ?

Re: [GENERAL] Syncing Data to Production DB Server

2011-08-18 Thread Ben Chobot
On Aug 18, 2011, at 5:36 AM, Adarsh Sharma wrote: Dear All, I want some views on the below requirements : 1. I have a Postgres DB server with 25 GB database. It has more than 110 tables. I am using Postgresql 8.3 on a CentOs. 2. I have another system laptop that contains the same

Re: [GENERAL] Syncing Data to Production DB Server

2011-08-18 Thread Adarsh Sharma
Ben Chobot wrote: On Aug 18, 2011, at 5:36 AM, Adarsh Sharma wrote: Dear All, I want some views on the below requirements : 1. I have a Postgres DB server with 25 GB database. It has more than 110 tables. I am using Postgresql 8.3 on a CentOs. 2. I have another system laptop that

Re: [GENERAL] Syncing Data to Production DB Server

2011-08-18 Thread John R Pierce
On 08/18/11 9:03 PM, Adarsh Sharma wrote: I want a simple technique through which I update my production server easily. what if there's been data changes on the production server and different changes on the demo laptop? how do you plan on reconciling those differences? -- john r pierce

Re: [GENERAL] Syncing Data to Production DB Server

2011-08-18 Thread Adarsh Sharma
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

Re: [GENERAL] Syncing Data to Production DB Server

2011-08-18 Thread c k
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

Re: [GENERAL] Syncing Data to Production DB Server

2011-08-18 Thread Adarsh Sharma
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