Populating WebMatrix SQL Server Compact
are there any way开发者_StackOverflow中文版s to populate the WebMatrix sql server with some script so that I can test the website better? I need some data on my server. Any suggestions are welcome.
You can use ErikEJ's tools to get data from an existing SQL Server (Full) database and script it to fill a SQL Server Compact 4 database: http://erikej.blogspot.com/2010/02/how-to-use-exportsqlce-to-migrate-from.html
The sqlcecmd mentioned in the blog does just that (execute pregenerated queries), and I also have made a VS 2010 add-in: http://sqlcetoolbox.codeplex.com
精彩评论