How can we help you today? How can we help you today?

possible to compare SQLCE db?

trying to do development on SQLCE and use SQLCompare to diff against the production DB to generate an update script.

Can't seem to find how to get SQLCompare to "see" my SQLCE db. Don't have actual SQL Server installed on the dev box.

Can anyone advise me please?
travislaborde
0

Comments

3 comments

Sort by
  • David Atkinson
    Sorry, Compact Edition isn't supported. Unfortunatley this isn't in the same family of databases as the other SQL Server editions.

    David Atkinson
    Product Manager
    David Atkinson
    0
  • ErikEJ
    I have a (beta) feature in the SqlCeToolbox that allows db diff: http://sqlcetoolbox.codeplex.com
    ErikEJ
    0
  • travislaborde
    Thanks David - that's really too bad. SQLCE4 really makes for a nice development experience, with everything right there within the solution.

    Thanks Erik - I've tried the toolbox, but can't quite get it working. I've left a comment on the issue tracker. It would be really great for a free tool to one-up a major player like Red-Gate eh? If this post gets them to buy you out and make you a zillionaire, you'll give me a free copy I hope?
    travislaborde
    0

Add comment

Please sign in to leave a comment.