x

How to export Sql server data to Compact Sql database?

Hi All,

I want to export SQL server 2005 database tables data (.MDF) to Compact Sql 3.5 (or 4.0) database tables (.SDF) through T-Sql or SP.

Please help!!

Thanks

more ▼

asked Sep 22, 2012 at 05:09 PM in Default

avatar image

ssurve
18 1 1 6

If this is something to be repeated have you thought about using import//export wizard or SSIS package?

Sep 22, 2012 at 05:52 PM Shawn_Melton
(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first
more ▼

answered Oct 12, 2012 at 09:04 AM

avatar image

ramesh 1
2.2k 66 69 73

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x428

asked: Sep 22, 2012 at 05:09 PM

Seen: 2812 times

Last Updated: Oct 12, 2012 at 09:04 AM

Copyright 2017 Redgate Software. Privacy Policy