Advice Needed - Regarding Data Transfer Between Databases On Seperate Servers [modified]

It_tech

Hi all, Can any one advice on Data Transfer Between Same Databases On Seperate Servers ? Database A on Server 197.23.xxx Database B on server 197.23.xxxx The run on the same network. Any Information will be much appreciated. Many thanks

modified on Wednesday, November 11, 2009 1:34 PM

_Damian S_ · modified on Wednesday, November 11, 2009 1:34 PM

More info needed. If they are on the same network and the servers can "see" each other, there's no reason why you couldn't transfer data... BUT... are they the same kind of database? What is it? Is it SQL Server? Access? Foxpro? DBase? A filing cabinet with a cat5 connection?

I don't have ADHD, I have ADOS... Attention Deficit oooh SHINY!! Booger Mobile (n) - A bright green 1964 Ford Falcon - our entry into the Camp Quality esCarpade!! Do something wonderful - make a donation to Camp Quality today!!

Mycroft Holmes · modified on Wednesday, November 11, 2009 1:34 PM

Some further information is needed. What is you database (SQL Server, Oracle, MySQL ???) Why is the transfer needed (development sync, replicated data, integrated query) Is this a one off operation? Frequency of transfer How do you expect the transfer to be initieated? Have you investigated the following to see if they suit your needs Linked Servers Replication You have some work to do before you can ask a sensible question.

It_tech

Thanks So Much for your response.Its Much appreciated. Both databases are in SQL Server 2008 database with same table structures and design. There are tables with the same structure in both database. I would like to copy Data from table in One databse tothe other Databse. Hennce ,I will have one Databse to put all my reporting etc..... I would like to run it twice a day.As i am running my report twice a day. Thanks

It_tech

Thanks So Much for your response.Its Much appreciated. Both databases are in SQL Server 2008 database with same table structures and design. There are tables with the same structure in both database. I would like to copy Data from table in One databse tothe other Databse. Hennce ,I will have one Databse to put all my reporting etc..... I would like to run it twice a day.As i am running my report twice a day. Thanks

Mycroft Holmes

I would look into replication as you seem to be able to identify 1 database as the "master". It is not a trivial subject, you will need to spend some time reading the BOL and understanding the implications of replication.

Never underestimate the power of human stupidity RAH

It_tech

Sorry to bother you again.Can you please get me some links in getting this specific problem.I seem to get a general database copy procedures. Many thanks for your help.