1

I need to migrate data to a SQL Server 2014 database from an existing SQL Server CE 4.0 database. I'm having difficulty because my computer runs SQL Server 2012 so I'm not able to port the data via a graphical wizard.

I am able to run scripts on all databases. I just don't know how to perform a the data migration without a graphical interface.

Improve this question
0

1 Answer 1

Reset to default
1

You can use my ExportSqlCe command line tools to export the schema and data, and then use sqlcmd to run the resulting script against a SQL Server 2014 database https://exportsqlce.codeplex.com/wikipage?title=Command%20line%20utilities&referringTitle=Documentation

Improve this answer
0

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.