Data Compare project files from version 3.x

General1

Hi,

What is the recommended way for converting a 3.x version data comparison project, with many fields greyed out (not being compared) and other indexes used for comparison into version 5 ?

Thanks,

Tom Harris

Hi,

I'm afraid we have changed the format of the files compleltely between version 3 and version 5. In version 5 the all the project information is persisted as xml, whereas version 3 used a proprietary binary format.

I know that it's a real pain, but the most reliable method is going to be recreating the projects in version 5 - the most we could hope to pull out of the version 3 files would be the servers and databases.

Do let us know if this is going to be a big hassle and we can look into writing a custom tool for you.

Thanks,

Tom Harris

Red Gate Software

General1

Hi,

thanks for your reply.

To give you an impression of how big the project file is: it involves a 400 tables, customized not to compare guids and datetimes, as it is a test comparison project on several databases - the tests diverge on the created guids and times.

Instead we have added identity fields to those tables, to be able to compare records added in the same order, as the tests should do everything in an automated way. Therefore we cannot use the normal primary key indexes.

In the end we have a quite customized project file of about 4MB in size.