we are having 2 MS SQL 2008 servers, where the first one is our main machine where our ERP (Navision) is running on.
Now, due to a customer request, I need to send data from our main sql server into our second sql server. But not everything, only some specific datasets (only if the specific customer is affected)... not only on inserts, but also on updates and on multiple
I am not quite sure which technology to use for that, I tried to read something about Integration Services and Trigger, but as I am not really into both of them and not sure what technique would be the most suitable, I'd like to ask the experts here for
The affected rows might be around 2-10% of our total inserts / updates a day.
Any help would be appreciated!
View Complete Post