Is there any tool which schema compares directly 2 SQL CE databases. VS2010 not working for CE as well as every commercial tool i have seen. How would you approach this problem?
+1
A:
Can you compare them on the SQL Server side? CE databases should be replicas of a master db.
Beth
2010-09-29 19:36:17
I don't understand how to achieve this since you cant attach a CE database on the SQL Server. I don't use replicas of a master db. You always follow this method?
2010-09-29 19:52:43
When I've worked with CE databases in the past, we've started with a SQL Server db and then used merge replication or RDA to read or write data and ActiveSync to sync the disconnected device when it's back in its cradle. If you don't have a master db your CE dbs came from, you can't compare them that way.
Beth
2010-09-29 20:01:13
I see. Thank you.
2010-09-29 20:19:43