possible to compare SQLCE db?

travislabordetravislaborde Posts: 3
edited December 7, 2010 8:32AM in SQL Compare Previous Versions
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?
· Share on Twitter

Comments

  • David AtkinsonDavid Atkinson Posts: 1,462 Rose Gold 2
    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
    Product Manager
    Redgate Software
    · Share on Twitter
  • ErikEJErikEJ Posts: 5
    I have a (beta) feature in the SqlCeToolbox that allows db diff: http://sqlcetoolbox.codeplex.com
    · Share on Twitter
  • travislabordetravislaborde Posts: 3
    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?
    · Share on Twitter
Sign In or Register to comment.