30 martie 2012 00:47
Dear all Experts,
We are looking for a way to have sales data to flow from 1 database to another database on same SQL server. Can we build or have a link between 2 database? If yes, how to and how much effort will that be?
2 aprilie 2012 04:13
There are two ways off the top of my head.
1. Trigger on the Sales Data table or tables on insert/update/delete that does the same to the other database.
2. Replication - fairly overkill but more transparent as you will notice failures in data transfer. Although replication is most complex of the two.
This is not the exact solution but I am sure you can do a bit if reading, Concentrate on 1 and 2 if you are interested.
Kind Regards Nick Kemp.
- Editat de Freedomofmovement 2 aprilie 2012 04:14
2 aprilie 2012 08:37
Thanks for the reply. Would a SQL developer knows how to do a link replication? Export data from DB1 and Insert into DB2??