Re: Syncing Data to Production DB Server
| От | c k |
|---|---|
| Тема | Re: Syncing Data to Production DB Server |
| Дата | |
| Msg-id | CAN2Y=uM-EVkjLEeVE4he8UF0Ogm=u6mNov5hnCkYT=5W1gq+HA@mail.gmail.com обсуждение исходный текст |
| Ответ на | Syncing Data to Production DB Server (Adarsh Sharma <adarsh.sharma@orkash.com>) |
| Список | pgsql-general |
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
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.sharma@orkash.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 KulkarniOn Fri, Aug 19, 2011 at 10:18 AM, Adarsh Sharma <adarsh.sharma@orkash.com <mailto:adarsh.sharma@orkash.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.sharma@orkash.com <mailto:adarsh.sharma@orkash.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
В списке pgsql-general по дате отправления: