开发者

Run exe file to downsize SQL Server to SQL Server CE

开发者 https://www.devze.com 2023-03-18 05:48 出处:网络
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.

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.

0

精彩评论

暂无评论...
验证码 换一张
取 消