Export SQL2005 to Compact Edition 3.5

• Santiago E. Perez

  Right there with Babe

  Points: 715

  More actions

  May 19, 2009 at 2:11 pm

  #200656

  Hello, new to COmpact Edition. I need to basically replicate all objects including table structures, FK Constraints, views, procs etc. that I have in SQL 2005 database to a CE 3.5 Database. What's the best way of doing this? I tried running scripts but got all kinds of errors.

• spidergen

  SSC Enthusiast

  Points: 115

  More actions

  August 7, 2009 at 1:04 am

  #1035803

  Hey,

  try this: http://www.johnnycantcode.com/page/SQL-Server-to-SQL-Server-Compact-Edition-Database-Copy.aspx

  Maybe you have to add some functionality for your case. I did some extensions to the code and everything works fine!

• Santiago E. Perez

  Right there with Babe

  Points: 715

  More actions

  August 7, 2009 at 9:01 am

  #1036059

  Thanks, will give it a try.