How Do I Populate A Sql Server Compact Database?

So I'm building a windows app, and as a result, I'm going to use SQL Server Compact instead of the normal SQL Server as I figure it can then be run on any computer, not just one wi

Solution 1:

You can use my SQL Server Compact scripting Tools for this: http://sqlcetoolbox.codeplex.com (VS add-in) and http://exportsqlce.codeplex.com (command line)