Comments
Sort by recent activity
I managed to do it, but I still have an issue. What I do now:
- use sql compare sdk to compare and synchronize live database to a folder
I use ADO.NET to execute scripts one by one in an ADO.NET transaction
- use sql data compare sdk to compare and synchronize database to a folder
I use ADO.NET to execute data scripts one by one in an ADO.NET transaction
What I would like to do:
- compare scripts and get differences
- open an ADO.NET transaction
- synchronize script differences using ADO.NET
- compare static data and get differences - here I have a problem, the tables are locked by previous ADO.NET transaction, I would like to pass the transaction to sql data compare but I didn't find how to do it
- synchronize data differences using ADO.NET
- commit ADO.NET transactions if all good
The whole purpose of this is to have a single transaction for scripts and static data, now I have two and if static data synchronization fails, the database is not coherent anymore
Thank you / comments
I managed to do it, but I still have an issue. What I do now:
- use sql compare sdk to compare and synchronize live database to a folder
I use ADO.NET to execute scripts one by one in an ADO.NET tr...
Thank for your quick reply, I will look into it. / comments
Thank for your quick reply, I will look into it.