SQL Server Compact 3.5 and 4.0 Toolbox add-in for Visual Studio. This add-in adds several features to help your SQL Server Compact development efforts: Scripting of tables and data, import from SQL Server and CSV files and much more.
Very useful tool. Great for someone who is not particularly experienced with SQL DB management / editing. Clean and familiar (VS2010 icons) browsing with a no frills SQL editor with auto-generated queries. The only thing I use the standard Server Explorer for now is Table creation.
Hi Erik, Thanks for this wonderful tools. The only thing I can think of for the next releases is a kind of progress bar or the number of rows imported like SSMS import dialog. Your tool has created a long SQL from a CSV file and right now I'm running it and I don't know how far is it. All I can do is looking to the size of the sdf file to make sure it's still working :) THANKS Mohsen
I am not able to install the VSIX, I've downloaded. I'm using VS 2012 express for WP. I get "Installation Failed" error box "This extension is not installable on any currently installed products.
4/14/2013 8:10:22 PM - Searching for applicable products...
4/14/2013 8:10:23 PM - Found installed product - Microsoft Visual C# Express 2010
4/14/2013 8:10:23 PM - Found installed product - Microsoft Visual Studio Express 2012 for Web
4/14/2013 8:10:23 PM - Found installed product - Microsoft Visual Studio Express 2012 for Windows 8
4/14/2013 8:10:23 PM - Found installed product - Microsoft Visual Studio Express 2012 for Windows Phone
4/14/2013 8:10:23 PM - Found installed product - Global Location
4/14/2013 8:10:23 PM - VSIXInstaller.NoApplicableSKUsException: This extension is not installable on any currently installed products.
Could you please help me with getting this installed?
I downloaded your SQL Server Compact Toolbox, when I right click SQL Sever Compact Data Connections, the Add SQL Server Compact 4.0 Connections is disabled. Please help.
I am using Visual Studio Ultimate with SP1.
We are using sql server compact files to store data for our application. For associating these files with our application we have chosen the file extension *.dfm. Unfortunately the connection dialog will not let me open the file (OK button is grayed out). "Test connection" works and opening the file after renaming to *.sdf works also.
Can you always enable the OK button regardless of the file extension? Thank you for providing such a great tool! We used to use the sql server management studio for this task but MS decided to kill this functionality for whatever reason.
Currently I am using the Microsoft supplied dialog to get connection information in some cases, and this dialog only accepts .sdf files. I will change this so I only use my own dialog, I have logged a Work item here: http://sqlcetoolbox.codeplex.com/workitem/list/basic
Now I see what my problem was, I had read this article but apparently did not read the note to initialize my connection with SQLCE
NOTE: Notice that the Chinook DataContext class is initialized with a SqlCeConnection object, I could not make it work with a full connection string, or the name of an existing connection string setting in app.config.
thank you very much for your help now I have clear
Is it possibe to install SQL Server Compact Addin for VS Expresse for Web? I get the following error:
Found installed product - Microsoft Visual Studio Express 2012 for Web
VSIXInstaller.NoApplicableSKUsException: This extension is not installable on any currently installed products.
Thanks for your help.
always get this error when I try to import from a csv file
Error Code: 80040E14
Message : Data conversion failed. [ OLE DB status value (if known) = 2 ]
Minor Err.: 26306
Source : SQL Server Compact ADO.NET Data Provider
Num. Par. : 2
a demo version of a commercial program created the table based on the same csv, so the table and csv type should be ok.
When I try to generate Linq2Sql datacontext, it gives me "Could not find SQLMetal location in registry", I've looked at dll's and found this: string sqlMetalPath = (string)Registry.GetValue(@"HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SDKs\Windows\v7.0A\WinSDK-NetFx40Tools", "InstallationFolder", null);
I've added following value to registry(there was also similar value to this, only with v8.0A), but error message didn't went away. I think it would be better to allow choose sqlmetal path if registry value not found or smth.
sqlmetal is located here:
"C:\Program Files (x86)\Microsoft SDKs\Windows\v8.0A\bin\NETFX 4.0 Tools\SqlMetal.exe"
"C:\Program Files (x86)\Microsoft SDKs\Windows\v7.0A\Bin\SqlMetal.exe"
I have only VS2012 RTM installed.
I've installed the Toolbox on a Windows 7 64bit system. I can see only what looks to be standard menu options. None of the advanced menu options are available. Did I miss something - from what I can tell eveything is installed.
I guess I should reply with the defacto dhoooo....
Yes; I did not realize the toolbox came with its own interface - thought it extended the server explorer interface - I guess that's what you get when you don't read the documentation.
I got this exception when I'm trying to export schema and data from a SqlCe 4.0 Db
How can I get over this ?
QuickGraph.NonAcyclicGraphException: Exception of type 'QuickGraph.NonAcyclicGraphException' was thrown.
at QuickGraph.Algorithms.TopologicalSort.TopologicalSortAlgorithm`2.BackEdge(TEdge args)
at QuickGraph.Algorithms.Search.DepthFirstSearchAlgorithm`2.OnBackEdge(TEdge e)
at QuickGraph.Algorithms.Search.DepthFirstSearchAlgorithm`2.Visit(TVertex root)
at QuickGraph.Algorithms.TopologicalSort.TopologicalSortAlgorithm`2.Compute(IList`1 vertices)
at QuickGraph.Algorithms.AlgorithmExtensions.TopologicalSort[TVertex,TEdge](IVertexListGraph`2 visitedGraph, IList`1 vertices)
at QuickGraph.Algorithms.AlgorithmExtensions.TopologicalSort[TVertex,TEdge](IVertexListGraph`2 visitedGraph)
at ErikEJ.SqlCeScripting.Generator4.ExcludeTables(IList`1 tablesToExclude)
at ErikEJ.SqlCeToolbox.Commands.DatabaseMenuCommandsHandler.ScriptDatabase(Object sender, ExecutedRoutedEventArgs e)