473,396 Members | 1,725 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,396 software developers and data experts.

Synchronize between two database tables

HI all can anyone help me with this.
I have two databases, one at my local host and second one on a web server with same tables. I have to make some changes to my local database and I need to update all those changes to the on line database. A table can take thousands of records even millions. Suppose there are 50,000 records in a table and I add two more records to my local database. Now I have to update these changes to the other database. What is the best way I can synchronize between two tables. Any change made to the one table should be easily updated at other place. Please help. Thanks in advance.
Jan 11 '08 #1
1 3952
r035198x
13,262 8TB
HI all can anyone help me with this.
I have two databases, one at my local host and second one on a web server with same tables. I have to make some changes to my local database and I need to update all those changes to the on line database. A table can take thousands of records even millions. Suppose there are 50,000 records in a table and I add two more records to my local database. Now I have to update these changes to the other database. What is the best way I can synchronize between two tables. Any change made to the one table should be easily updated at other place. Please help. Thanks in advance.
If you are making lots of changes to only one of the databases then dropping and recreating from a dump is simpler.
Jan 11 '08 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

6
by: alex via SQLMonster.com | last post by:
Hi, anybody can help me. How can i synchronize 2 tables on 2 different sql servers 2000 i mean TABLE1(col1, col2, col3, col4) and TABLE1(col1, col2, col3, col4, col5, col6) the first 3...
4
by: gene.ellis | last post by:
Using a web interface, I am placing text into a SQL database. From time to time, I would like to synchronize one of my other tables in the database with the table that I am inserting content into....
0
by: Prasad Patil | last post by:
Hi, i need to develop asp.net application to synchronize my Prod & Live env Any sample apps or links for reference would be of great help Regards, Prasad
3
by: dusty | last post by:
Hi, I'll try to simplify the problem: I created a table "TestTable" in a database on the SQL server. The first column, 'id', is the primary key with a auto-increment identity. I want to work...
2
by: Pascal Polleunus | last post by:
Hi, I need to synchronize some tables from a database (master) to another one (slave). Both servers are running Debian Woody with PostgreSQL 7.2.1 (postgresql 7.2.1-2woody4). The databases are...
3
by: Elioth | last post by:
Hi, I want to synchronize Access and SQL database schema. I have running a application and I want sync database because when I create a new Table in the database I need this table in all client...
3
by: pradeep | last post by:
Hi, I amnew to this group and lucky to have found this group. i have a master table which has different types of application say Desktop, Mainframes, etc. I have an individual table for each...
1
by: John | last post by:
Hello, I need to synchronize one access database with other access database. Tables and fields are off course same. Can someone tell me how to achieve this? Regards
1
by: rbarber | last post by:
I have to synchronize 2 databases hourly but am having difficulty maintaining foreign key relations. These tables use auto-increment columns as primary keys, with child records in other tables...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.