Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
lbmmoh
Starting Member
2 Posts |
 Posted - 2008-03-27 : 12:19:24
|
| Im an sql newb and trying to understand how I can automatically copy data from one dtabase to another systems database on the same server.We have two differnt applications, but both share customer information.Each time a customer contacts us via online chat, we want to copy their entire chat transcript into our CRM's customer account. So the folks that use the CRM can see the past chat histories. I hope this makes sense.Where can i look to get started on this?Thanks |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-03-27 : 20:00:56
|
| How big is data? Use backup/restore for whole databases |
 |
|
|
gogetter
Starting Member
18 Posts |
Posted - 2008-03-28 : 12:15:33
|
| Hi lbmmoh, There are a couple of ways you can approach this task. One way would be to configure a trigger that fires everytime a new chat is logged into the database on your main server. The trigger would simply copy that same data to the destination database server through an insert statement. Depending on how often chats are logged this could present a problem because you don't want a trigger firing that often if you can help it. Have you considered setting up a DTS package to copy the entire table where your chats are being stored to the destination server database? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-28 : 22:52:39
|
| Take look at transactional replication. By the way, trigger may affect performance. |
|
|
|
lbmmoh
Starting Member
2 Posts |
Posted - 2008-03-30 : 21:38:57
|
| Thank you everyone. Im not sure of the size of each chat yet as I am in the process of installing it. THey are plain text files, nothing advanced about them I believe. I will look into transactional replication. It seems like there might be some database issues, becauase the chat will be on mysql and the crm is on Oracle. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-30 : 22:26:21
|
| Nothing on sql server? Then forget what we said since we are talking about MS SQL server. |
|
|
|
|
|
|
Script to copy data from one database to another?