I’ve been using Scribe insight to synchronise Dynamics CRM and a SQL database on our webserver. It is as the title suggests it’s a love hate relationship, when it works fine it’d great, but when it doesn’t it really doesn’t work!

It doesn’t help when the data source isn’t in the best order it could be, so long as the data transfer is simple Scribe works fine, but as soon as it’s get complicated it gets though. It really struggles when trying to update linked tables, I think that the solution for this may lie with stored procedures. Having finally worked out how to get scribe to use stored procedures I’m going to try this tomorrow and find out if this works as I hope it will. Multiple linked table update/inserts should be easier as the id’s can be updated in the same procedure, also it should speed up the queries as this can get a little slow presently.