Does anyone know of a tool similiar to RedGate's SQL Data Compare that works with Microsoft SQL Server Compact 3.5?
A:
Have you tried SQL Compare from starinix? They say it supports SQL Server (All Editions) so that may include compact edition.
This software does work as I have used it (for Yukon). It's also freeware which saves worrying about licensing.
Wayne
2009-03-11 13:00:49
Cheers Wayne! I'll check it out and let you know.
Duncan Edwards
2009-03-11 13:04:49
No good. Does not support Compact.
Duncan Edwards
2009-03-11 14:03:22
Ok, well at least you found a resolution anyway!
Wayne
2009-03-12 00:55:08
+1
A:
In the end I solved this problem by Exporting my 2 SQL Server Compact Databases to SQL Server Express 2005 (although 2008 would work) using Data Port Console.
I then compared them using Red Gate SQL Data Compare.
This solution works just fine for me.
Duncan Edwards
2009-03-11 14:28:08
A:
Not sure, but you could also have a look at the Apex SQL tools - Apex SQL Diff and Apex SQL DataDiff. There website is here. They don't specifically mention SQL Server Compact - but I'm sure you could inquire with them.
Red-Gate and Apex are my #1 choices for any kind of SQL tools :-)
Marc
marc_s
2009-03-12 11:42:45