0

I don't know if this is a newbie question or not, I want to export some tables from "full" SQL Server 2005 database to a SQL Server Compact Edition database through a CLR stored procedure.

I know it is possible through SSIS.

Improve this question
2
  • 2
    What have you tried? Commented Sep 25, 2012 at 9:51
  • Compact Sql data will present at client machine with Master tables. When any user update the records in any master table, SQL Server will export that table data to shared CE db and application will download it to get updated information. Commented Sep 25, 2012 at 10:22

1 Answer 1

Reset to default
1

This article shows how to migrate between sql server and sql server compact using SQL Server Compact Toolbox. so you can use the sql server compact script generated from your database to create CLR stored procdure

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

Comments

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.