Database modeling

[Guest]

In our last project, we created (in notepad no less) the database generation
scripts. Needless to say it sucked.

Is there a database modelling tool that is able to produce SQL CE compatible
scripts? (I tried SQL Server but you need to edit the results quite a bit
before they are compatible).

I need the usual stuff, i.e. add tables and relationships between them and
print a graphical tree...

Thanks.

 

[W.G. Ryan eMVP]

www.deklarit.com is probably the best product for this and it's also
targeted to SQL CE