0

Simple problem. I have an SQL Server database (MyData.mdf) and I want to convert it to a Compact database. (MyData.sdf) Just can't find the proper tool which can do this for me.

And I would also be able to convert the compact database back to a regular SQL Server database...

Improve this question

2 Answers 2

Reset to default
1

They aren't directly convertible from one to the other; many aspects of SQL Server aren't supported in SQL Compact.

You might consider using SQL Server Integration Services (SSIS) to help manage the transformations.

Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

0

Have you tried any hidden options from SQL Server Studio?

Improve this answer

1 Comment

No but since SQL Server studio allows management of both normal SQL server and compact editions I'm sure there are some options which wouldn't be visible at first glance but would be somewhere as a suboption of import/export.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.