Last post Jun 14, 2012 02:56 AM by vikas227
Jun 14, 2012 02:56 AM|vikas227|LINK
I'm trying to convert a SQL Server 2008 R2 database to SQL Server CE 4.
The only solution I can find is detailed here: http://erikej.blogspot.com/2010/02/how-to-use-exportsqlce-to-migrate-from.html.
However, I've downloaded the .exe and opened it - it just pops up with a command window which says something then immediately closes before I can read it; which I assume is just it installing.
However, if I then open a command prompt and type any of the instructions in that example and run e.g.
Export2sqlce "Data Source=(local);Initial Catalog=AdventureworksLT;Integrated Security=True" AW.sqlce
I just get "'Export2sqlce' is not recognized as an internal or external command, operable program or batch file."
What am I doing wrong?
EDIT: I needed to run the full path to the exe and the extension for it to work. Like this:
C:\Users\admin\Desktop\Export2SQLCE.exe "Data Source=(local);Initial Catalog=Northwind;Integrated Security=True" Northwind.sql