Results 1 to 8 of 8
-
Tsikot Member Rank 4
- Join Date
- Jan 2003
- Posts
- 2,979
July 19th, 2007 04:37 PM #1Situation:
Two servers both having SQL 2000 running on win2k with full replicated database on both servers
Question:
Would different transactions on both databases cause data anomalies when consolidating their database?
-
July 19th, 2007 11:55 PM #2
1.) How will you be able to replicate a database if you're not duplicating it from the same source? Di ko nagets ata tanong mo. hehehe
2.) Where did you replicate it? I assume Database Server A is replicated at Database Server B and Database Server B is replicated at Database Server A?
-
July 20th, 2007 07:23 AM #3
-
July 20th, 2007 09:13 AM #4
so you have two database servers that are replicated by other boxes? tama ba? parehong master copies yung 2 servers mentioned?
or tama si froshie1 na,
master and slave yung 2 servers?
-
July 20th, 2007 09:27 AM #5
-
Tsikot Member Rank 4
- Join Date
- Jan 2003
- Posts
- 2,979
July 20th, 2007 10:02 AM #6well i have two servers. server A is the running server. server b is a standby server. server b is more powerful. downtime is a no-no
i plan to replicate the database on server B.
Problem: several programs are using the DB. I need to manually edit the source code to run using server B and manually configure each client to use server B as their database. If i will run both servers as replicated servers and those programs accessing the two servers
1. would those programs run as if they are seeing only one database?
2. would consolidation of data run smoothly and not encounter any problems?
-
July 20th, 2007 10:23 AM #7
If you have server B as a standby, then your mirroring software should take care of replicating between the two databases. If server A fails, you need to remap your DNS to point to server B. All your programs should reference the server name, not the IP.
-
Tsikot Member Rank 4
- Join Date
- Jan 2003
- Posts
- 2,979
July 20th, 2007 02:38 PM #8
sinabi moh! i hardly see my children now. when they were young, schedules were more predictable.
Traffic!