0

I need to convert a SQL Server Compact database file to SQL Server, so I think generate script is the best way, but I can't find anything in SQL Server CE Toolbox 3.5

Is there a workaround?

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
Andiana
  • 1,912
  • 5
  • 37
  • 73
  • Here is a Microsoft tutorial on the subject http://www.microsoft.com/web/post/migrate-a-database-to-sql-server – WorkSmarter Mar 09 '15 at 02:44
  • 1
    possible duplicate of [Moving data from SQL Compact to SQL Server 2008](http://stackoverflow.com/questions/2229572/moving-data-from-sql-compact-to-sql-server-2008) – WorkSmarter Mar 09 '15 at 02:46
  • 1
    In the SQL Server Compact Toolbox you can both script a database or Migrate directly – ErikEJ Mar 09 '15 at 06:36
  • Oh thank Erik, I just didn't see it, the third item in context menu: "Script Database", I can't believe meet the author here :) – Andiana Mar 10 '15 at 00:34

0 Answers0