Generate SQL Compact database from Sql Server database

Asked Apr 22 '14 at 04:37

Active Apr 22 '14 at 04:40

Viewed 44 times

I wish to migrate from my SQL Server database to a SQL Server Compact database. I have tens of tables with tons of columns, it will be a life-time taking process to generate the tables and their fields manually from scratch.

Is there some faster way to generate the tables from SQL Server?

edited Apr 22 '14 at 04:40

asked Apr 22 '14 at 04:37

Mahdi Tahsildari

13,065
14
55
94

You could try `Generate Scripts` option which can generate schema as well as with data also. – Vishal Suthar Apr 22 '14 at 04:41
@VishalSuthar can you give me a point to start from? – Mahdi Tahsildari Apr 22 '14 at 04:42
1

You can refer this: [Generate a Script (SQL Server Management Studio)](http://technet.microsoft.com/en-us/library/ms178078(v=sql.105).aspx) and also this: [Exporting data In SQL Server](http://stackoverflow.com/a/1515975) – Vishal Suthar Apr 22 '14 at 04:44
@VishalSuthar I generated the scripts from Database, how can I run them on my local database (.sdf database in visual studio)? – Mahdi Tahsildari Apr 22 '14 at 05:17

Generate SQL Compact database from Sql Server database

0 Answers0