tag:blogger.com,1999:blog-5238131531249720750.post2707722546535056597..comments2024-01-22T04:58:27.847+01:00Comments on Everything SQL Server Compact: Migrating databases between SQL Server and SQL Server CompactErikEJhttp://www.blogger.com/profile/12641272161018114573noreply@blogger.comBlogger31125tag:blogger.com,1999:blog-5238131531249720750.post-73816082818397521682016-08-26T11:29:05.191+02:002016-08-26T11:29:05.191+02:00Sandeep: You could make the sdf file read-only, or...Sandeep: You could make the sdf file read-only, or you could create a table in the sdf file with a single row and a bit column, and set it to true ErikEJhttps://www.blogger.com/profile/12641272161018114573noreply@blogger.comtag:blogger.com,1999:blog-5238131531249720750.post-39150813752636928882016-08-26T11:21:45.792+02:002016-08-26T11:21:45.792+02:00Hi Erik,
I need to copy the data from existing SQ...Hi Erik,<br /><br />I need to copy the data from existing SQLServer Db files to .sdf files and i developed a solution for that. Its working great. Now i need to mark the database once it gets copied so that i can prevent copying it again when we run the solution in the same system in future.<br /><br />Please advise. <br /><br />Thanks in advance!!Anonymoushttps://www.blogger.com/profile/06161247424627525907noreply@blogger.comtag:blogger.com,1999:blog-5238131531249720750.post-34595744157941534602016-07-16T09:28:24.247+02:002016-07-16T09:28:24.247+02:00Shrikant: I assume you are doing it wrong - I have...Shrikant: I assume you are doing it wrong - I have some working code here: https://github.com/ErikEJ/SqlCeToolbox/blob/master/src/GUI/SqlCe35Toolbox/WinForms/ResultsetGrid.cs ErikEJhttps://www.blogger.com/profile/12641272161018114573noreply@blogger.comtag:blogger.com,1999:blog-5238131531249720750.post-79379395000506282682016-07-15T13:54:59.153+02:002016-07-15T13:54:59.153+02:00Hi sir
i have Compact CE database file (.sdf) i ...Hi sir <br /> i have Compact CE database file (.sdf) i just want to connect it using windows forms application.i used your toolbox to working on it like performing queries migrating from CE to SQL Server. but now i want to directly connect to .sdf file fetching some data from it and insert that data into the SqlServer tables. i follow all the processes like Connection, Command, Dataadapter and then filling data into dataset, but when i reach the dataset fill i found that there is no data in dataset. do you have any idea..... <br />Thanx and regards <br />Anonymoushttps://www.blogger.com/profile/12246302496156648962noreply@blogger.comtag:blogger.com,1999:blog-5238131531249720750.post-4686642876954568872015-12-03T17:47:04.549+01:002015-12-03T17:47:04.549+01:00Sanvir: Thanks: If you use my tools, I would be ve...Sanvir: Thanks: If you use my tools, I would be very grateful for a rating or review here:<br /><br />https://visualstudiogallery.msdn.microsoft.com/0e313dfd-be80-4afb-b5e9-6e74d369f7a1/view/Reviews ErikEJhttps://www.blogger.com/profile/12641272161018114573noreply@blogger.comtag:blogger.com,1999:blog-5238131531249720750.post-36966670118720043262015-12-03T14:58:51.466+01:002015-12-03T14:58:51.466+01:00Thank you for all your blog posts and your invalua...Thank you for all your blog posts and your invaluable tools! It really makes dev'ing a breeze.Anonymoushttps://www.blogger.com/profile/01337619306174158224noreply@blogger.comtag:blogger.com,1999:blog-5238131531249720750.post-78747563639462583952015-12-03T14:58:14.002+01:002015-12-03T14:58:14.002+01:00Just want to say thank you for your blog posts and...Just want to say thank you for your blog posts and tools. You are also always willing to help. <br />I really appreciate it.Anonymoushttps://www.blogger.com/profile/01337619306174158224noreply@blogger.comtag:blogger.com,1999:blog-5238131531249720750.post-47281163232538882722015-02-17T13:35:52.115+01:002015-02-17T13:35:52.115+01:00Nanda: Yes, of course : http://erikej.blogspot.dk/...Nanda: Yes, of course : http://erikej.blogspot.dk/2013/03/sql-server-compact-code-snippet-of-week_8.html ErikEJhttps://www.blogger.com/profile/12641272161018114573noreply@blogger.comtag:blogger.com,1999:blog-5238131531249720750.post-61717416483316245742015-02-17T11:38:24.850+01:002015-02-17T11:38:24.850+01:00Hi,
I want to migrate my SQL CE DB to SQL 2012 DB...Hi,<br /><br />I want to migrate my SQL CE DB to SQL 2012 DB. Is there any SDK compatibl;e to be used in .Net?Nandahttps://www.blogger.com/profile/08598509050836392294noreply@blogger.comtag:blogger.com,1999:blog-5238131531249720750.post-31225647818648605872014-09-22T11:42:04.642+02:002014-09-22T11:42:04.642+02:00Mohamed: Please use the MSDN forum for lengthy sup...Mohamed: Please use the MSDN forum for lengthy support issues. Master is a system database, and is not for user data<br />ErikEJhttps://www.blogger.com/profile/12641272161018114573noreply@blogger.comtag:blogger.com,1999:blog-5238131531249720750.post-81081366103501728382014-09-22T11:42:04.061+02:002014-09-22T11:42:04.061+02:00Mohamed: Please use the MSDN forum for lengthy sup...Mohamed: Please use the MSDN forum for lengthy support issues. Master is a system database, and is not for user data<br />ErikEJhttps://www.blogger.com/profile/12641272161018114573noreply@blogger.comtag:blogger.com,1999:blog-5238131531249720750.post-54615278386543014522014-09-22T11:35:19.233+02:002014-09-22T11:35:19.233+02:00Hi ErikEJ
i am very grade about your help to me
i...Hi ErikEJ<br />i am very grade about your help to me <br />i make it but make some diffirent first i make .sql script not .sqlce but it insert only tables with out dataim master data and i want to ask here why in master data ??<br />and after that i copy what inside .sqlce and but it in the .sql and execute<br />and all data convert success and i make .mdf data separated from the server and try to contact it to vb studio but it give me this error<br />http://im51.gulfup.com/jljhcw.bmp<br /> so why ?? and please i want from u the final answer of can i use .sdf in network by but it on the server and share it to users if yes How by Detail and clarify the steps"i have sql compact 4 Now"?? if no can i get sure that sql data file .mdf will get me what i need in the network ???<br />sorry about all this question but i am in a very big Problem to make my program work on local net work as fast as i canMohammedhttps://www.blogger.com/profile/16181035771062331017noreply@blogger.comtag:blogger.com,1999:blog-5238131531249720750.post-84325945951300693172014-09-22T08:26:29.319+02:002014-09-22T08:26:29.319+02:00You need to connect to the database, or create a n...You need to connect to the database, or create a new one.ErikEJhttps://www.blogger.com/profile/12641272161018114573noreply@blogger.comtag:blogger.com,1999:blog-5238131531249720750.post-13123678737417158972014-09-21T22:33:04.271+02:002014-09-21T22:33:04.271+02:00thank u about your reapply but
http://im53.gulfup....thank u about your reapply but<br />http://im53.gulfup.com/fMhvt2.bmp<br />see please this image this after i opened the script on sql server what is the problem??<br />Mohammedhttps://www.blogger.com/profile/16181035771062331017noreply@blogger.comtag:blogger.com,1999:blog-5238131531249720750.post-82837695730176909682014-09-21T08:43:06.191+02:002014-09-21T08:43:06.191+02:00Mohamed: Open the .sqlce script in Management Stud...Mohamed: Open the .sqlce script in Management Studio, connect to your new SQL Server Express db, and run the script.ErikEJhttps://www.blogger.com/profile/12641272161018114573noreply@blogger.comtag:blogger.com,1999:blog-5238131531249720750.post-30782424642452324762014-09-20T22:13:35.308+02:002014-09-20T22:13:35.308+02:00You can now open the generated script in Managemen...You can now open the generated script in Management Studio and execute it against a SQL Server database, or run it with sqlcmd as described above.<br /><br />____<br />i am not under stand i am want to convert my sql compact 4 to sql express database "becouse i failed to share .sdf file on local network and alot of people said to me it is not a proved that " so i am already convert sql compact file to .sqlce<br />and i want now to totaly convert it to sql express 2014 studio what should i do i tried but uselessMohammedhttps://www.blogger.com/profile/16181035771062331017noreply@blogger.comtag:blogger.com,1999:blog-5238131531249720750.post-44952790932980031862014-03-18T19:57:02.614+01:002014-03-18T19:57:02.614+01:00Nenad: Suggest you post an issue with more informa...Nenad: Suggest you post an issue with more information on the Codeplex issue trackerErikEJhttps://www.blogger.com/profile/12641272161018114573noreply@blogger.comtag:blogger.com,1999:blog-5238131531249720750.post-40007953219818606282014-03-18T15:56:16.425+01:002014-03-18T15:56:16.425+01:00Hi *.
I'm trying to export sql express db to s...Hi *.<br />I'm trying to export sql express db to sql ce, but I receive same message as Tanito. I have sqlce 4.0 runtime installed (x64) version.<br />Do you have any idea?<br />Thank you in advance.<br /> NenadNenadhttps://www.blogger.com/profile/06241196490188597416noreply@blogger.comtag:blogger.com,1999:blog-5238131531249720750.post-67769738670818734522013-06-13T11:28:26.069+02:002013-06-13T11:28:26.069+02:00Tanito: You must have the SQLCE 4.0 runtime instal...Tanito: You must have the SQLCE 4.0 runtime installed.ErikEJhttps://www.blogger.com/profile/12641272161018114573noreply@blogger.comtag:blogger.com,1999:blog-5238131531249720750.post-87633565475065407942013-06-12T22:54:42.119+02:002013-06-12T22:54:42.119+02:00Hi,
can you help with this please? May be you know...Hi,<br />can you help with this please? May be you know this one.<br />I'm trying to export a SQL Server to SQL Server Compact 4.0 and I'm getting this error:<br /><br />Application: SqlCe40Toolbox.exe<br />Framework Version: v4.0.30319<br />Description: The process was terminated due to an unhandled exception.<br />Exception Info: System.IO.FileNotFoundException<br />Stack:<br /> at ErikEJ.SqlCeScripting.SqlCeHelper4.FormatError(System.Exception)<br /> at ErikEJ.SqlCeToolbox.Helpers.DataConnectionHelper.ShowErrors(System.Exception)<br /> at ErikEJ.SqlCeToolbox.Commands.DatabaseMenuCommandsHandler.ExportServerDatabaseTo40(System.Object, System.Windows.Input.ExecutedRoutedEventArgs)<br /> at System.Windows.Input.CommandBinding.OnExecuted(System.Object, System.Windows.Input.ExecutedRoutedEventArgs)<br /> ...Tanitohttps://www.blogger.com/profile/14981554747815286288noreply@blogger.comtag:blogger.com,1999:blog-5238131531249720750.post-55649076901706427642013-03-20T16:09:29.203+01:002013-03-20T16:09:29.203+01:00Thank you very much :)Thank you very much :)Nonamehttps://www.blogger.com/profile/17545765984933696692noreply@blogger.comtag:blogger.com,1999:blog-5238131531249720750.post-10541672392148155092013-03-20T11:50:38.015+01:002013-03-20T11:50:38.015+01:00The command line should be:
ExportSqlCE40.exe &quo...The command line should be:<br />ExportSqlCE40.exe "Data Source=C:\test\SampleFile.sdf;" adsf.sqlErikEJhttps://www.blogger.com/profile/12641272161018114573noreply@blogger.comtag:blogger.com,1999:blog-5238131531249720750.post-12135778992315689532013-03-20T11:47:35.247+01:002013-03-20T11:47:35.247+01:00Hi Erik
May I ask your advice on something? I am ...Hi Erik<br /><br />May I ask your advice on something? I am a novice SQL Compact 4.0 Toolbox User.<br />I have a .sdf file, for which I would like to create the .sql script through command prompt. I need you to confirm the following:<br />After downloading the ExportSQLCE40.exe tool. I simply have to enter : ExportSQLCE40.exe "Data Source="Path.sdf";" name.sql<br /><br />Upon this entry, we are encountering the following error:<br /><br />C:\test>ExportSqlCE40.exe "C:\test\Sample File.sdf;" adsf.sql<br />Error: System.ArgumentException: Format of the initialization string does not co<br />nform to specification starting at index 0.<br />at System.Data.Common.DbConnectionOptions.GetKeyValuePair(String connectionSt<br />ring, Int32 currentPosition, StringBuilder buffer, Boolean useOdbcRules, String&<br />keyname, String& keyvalue)<br />at System.Data.Common.DbConnectionOptions.ParseInternal(Hashtable parsetable,<br />String connectionString, Boolean buildChain, Hashtable synonyms, Boolean firstK<br />ey)<br />at System.Data.Common.DbConnectionOptions..ctor(String connectionString, Hash<br />table synonyms, Boolean useOdbcRules)<br />at System.Data.Common.DbConnectionStringBuilder.set_ConnectionString(String v<br />alue)<br />at System.Data.SqlServerCe.SqlCeConnectionStringBuilder..ctor(String connecti<br />onString)<br />at System.Data.SqlServerCe.SqlCeConnection.set_ConnectionString(String value)<br /><br />at System.Data.SqlServerCe.SqlCeConnection..ctor(String connectionString)<br />at ErikEJ.SqlCeScripting.DBRepository..ctor(String connectionString)<br />at ExportSqlCE.Program.Main(String[] args)<br /><br /><br />Any ideas?<br /><br />Thanks, your help is much appreciated. <br />Nonamehttps://www.blogger.com/profile/17545765984933696692noreply@blogger.comtag:blogger.com,1999:blog-5238131531249720750.post-47026153797796787052012-10-29T08:18:43.841+01:002012-10-29T08:18:43.841+01:00Thierry: I think it is an issue with your unusualt...Thierry: I think it is an issue with your unusualtable name, so please try to rename it as suggested by me on CodePlexErikEJhttps://www.blogger.com/profile/12641272161018114573noreply@blogger.comtag:blogger.com,1999:blog-5238131531249720750.post-9859450166906988672012-10-28T14:50:54.348+01:002012-10-28T14:50:54.348+01:00I found one of the problems, it seems your script ...I found one of the problems, it seems your script cant handle float type as in your query every attribute is surrounded by single quotes, I manually create the table and move all float to nvarchar, and now I can at least use the import csv optionAnonymoushttps://www.blogger.com/profile/14432711284665065504noreply@blogger.com