Activity overview
Latest activity by cata_sun
All values for Message.MessageTypeID
Hello,
I use Sql Compare to synchronize 2 databases. In some situations Sql Compage give me some warnings of type RedGate.SQLCompare.Engine.Message. One property of RedGate.SQLCompare.Engine.Messag...
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.
Deploy Source control folder to remote database
Hello,
Here is my scenario:
- a SQL server database saved on a SVN server using Redgate SQL source control (schema and static data)
- i would like to publish schema and the static data modification...