Create delete update tables in one database to another database.

Question

Create delete update tables in one database to another database.

Viewing 5 posts - 16 through 19 (of 19 total)

You must be logged in to reply to this topic. Login to reply

sampathmeka SSC Enthusiast Points: 192 More actions · Answer 1

Thanks for the reply Williams!!

This was you question

I cannot help you without understanding the goal of your request. If you can answer why you need to do this and what problem you are trying to resolve - then maybe we can come up with a possible solution.

MyReply:

Actually my goal was to update the data across different servers in different locations(usa,uk,europe etc) where the data will be same in all servers.i will update the data in one server and all the other servers should be synced automatically.

Any update\Delete\Insert in any table should sync all the servers in different locations.

Hope you are clear with my goal now.

if you have any solution reply me otherwise just ignore the message ,sorry to disturb you this reply is to give clarity in my goal.

Sorry for troubling you!!!

Thanks,

Sampath

sampathmeka SSC Enthusiast Points: 192 More actions · Answer 2

Thanks for making your time for reply Chris!!

Is this just a one way transfer of information, from Database1 to Database2, or is there a need to also send updates from Database2 back to Database1?

MyReply:

It is one way update only Database1 to Database2,Database3,Database4 and so on .The updation of data is Database1 to other databases only not <b>vice-versa.</b>

once again thanks for reply Take Care

Thanks,

Sampath

Jeffrey Williams SSC Guru Points: 90303 More actions · Answer 3

sampathmeka wrote:

Thanks for making your time for reply Chris!!
Is this just a one way transfer of information, from Database1 to Database2, or is there a need to also send updates from Database2 back to Database1?
MyReply:
It is one way update only Database1 to Database2,Database3,Database4 and so on .The updation of data is Database1 to other databases only not <b>vice-versa.</b>
once again thanks for reply Take Care
Thanks,
Sampath

This is different from what you stated before...but okay. Replication from a single source to multiple destinations - you want transactional replication as Chris outlined.

Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

― Charles R. Swindoll

How to post questions to get better answers faster
Managing Transaction Logs

sampathmeka SSC Enthusiast Points: 192 More actions · Answer 4

Thanks for the reply Williams!!

Is it possible to provide any sample/example of transactional replication?

As I am totally new to this sql related stuff.

If you have time kindly help me

Thanks,

Sampath

sampathmeka SSC Enthusiast Points: 192 More actions · Answer 5

Thanks for the reply Williams!!

one more question i have

Question:- I have two databases in same server assume Realtime database and Backup database these two databases contains 25+ tables.

i have done insert/delete/update in Realtime database automatically Backup database should be updated.

Is there any option other than transactional replication to acheive the above requirement?

Thanks ,

Sampath