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.
Hi, thank you - and thank you! You did a great job here! Why does MS not buy this thing and integrates it into VS2010? Microsooooooft! Come and buy this tool and make this man rich!
The features provided are a great help with SQL Compact edition databases and the updates frequent (a bit too frequent, though). This saves time when creating a model. Thank you.
You Rock Erik!!! Thanks a ton for your efforts. This just works!!! and that is the best thing about it :)
I have been going through countless workarounds to no avail. Most examples mention a provider when creating the Data Source for the Data Entity but I never could get it to show up.
After waiting for so many months for VS 2010 SP 1 to come out, I found myself flabbergasted when I saw Microsoft did ZERO to help SQL Compact 4 users in managing their databases. I waited a lot to be able to use SQLCE4 in my Desktop app only to find myself out in the rain.
But here comes Erik with a great addon! The SQL Server Compact Toolbox is already, at the time of this writing, an almost complete replacement of SSMS, at least for what I need it! It's very light and works great, and what's even better, is that it's still actively developed, and I see a golden future ahead for it.
Hi ErikEj,
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.
Log --
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.
at VSIXInstaller.App.InitializeInstall()
at System.Threading.Tasks.Task.InnerInvoke()
at System.Threading.Tasks.Task.Execute()
Could you please help me with getting this installed?
Hi ErikEj,
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.
Daniel Flemming.
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
toolbox has an option that says add a LINQ to SQL DataContext class to the current project, and I'm using that class that I generated to populate a gridview
Ok, to use 4.0 you need to initialize the Datacontext with a SqlCeConnection instane, see http://erikej.blogspot.dk/2012/04/using-linq-to-sql-with-sql-server.html
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
Hi,
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.
Peter
ok;
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.
thx
Peter
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.Search.DepthFirstSearchAlgorithm`2.InternalCompute()
at QuickGraph.Algorithms.AlgorithmBase`1.Compute()
at QuickGraph.Algorithms.TopologicalSort.TopologicalSortAlgorithm`2.InternalCompute()
at QuickGraph.Algorithms.AlgorithmBase`1.Compute()
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)
View Large
