Run exe file to downsize SQL Server to SQL Server CE
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 co开发者_运维技巧mmand 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
For any command lin utility, you must either locate yourself to the folder where it resides, use the full path or place the file in a folder that is in the PATH environment variable.
精彩评论