Stack Overflow
Stack Overflow

Questions tagged [sql-server-ce-toolbox]

SQL Server Compact & SQLite Toolbox is a Visual Studio 2012 or higher add-in (for 3.5/4.0/SQLite) standalone app (for 3.5/4.0), that adds scripting, import, export, migrate, rename, run script, manage replication and more to your SQL Server Compact Data Connections in VS Server Explorer.

SQL Server Compact Toolbox is a Visual Studio 2010 Pro or higher add-in (for 3.5/4.0) and standalone app (for 4.0), that adds scripting, import, export, migrate, rename, run script, manage replication and more to your SQL Server Compact Data Connections in VS Server Explorer.

Link.

13 questions
8
votes
1 answer

Can I execute multiple statements in SQL Server Compact 4?

I'm trying to get multiple inserts to work in a single script using the SQL Compact 4.0 Toolbox and not having any luck. I keep getting a parsing error. I've even tried adding GO; between each statement like so.. INSERT INTO ... ; GO; INSERT INTO…
Shane Courtrille
  • 13,960
  • 22
  • 76
  • 113
4
votes
2 answers

SQL Server Compact 4.0 DbProvider - No

I'm using the SQL Server Compact/SQLite Toolbox for Visual Studio by ErikEJ. Environment is Windows 7 x64 with Visual Studio 2013.5 I'm following along in the example on the blog…
Alan
  • 306
  • 2
  • 10
1
vote
1 answer

SQL Server Compact 4.0 image column truncated to 8000

I am working with SQL Compact 4.0 for the first time and trying to insert data into an IMAGE column and most of the data is around 50kbytes. The problem I am getting is although the image column is supposed to be big enough the data is being…
Andrew Larkin
  • 11
  • 4
1
vote
2 answers

SQL Server CE Toolbox - VS 2010 plugin not allowing connections to 4.0

I've installed the SQL Server Compact Edition 4.0 runtime and DbFactory provider and everything. But after I've installed the SQL Server CE Toolbox (v3.2) from CodePlex, I still cannot seem to get any connections established. The info dialog seems…
marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
0
votes
0 answers

SQL Server Compact toolbox diff script doesn't work

I have two .sdf files and I tried run "Script Database diff" on "SQL Server Compact toolbox for runtime 4.0" to get differences between this two files, I got this as result: -- This database diff script contains the following objects: -- - Tables: …
Maddie Emerald
  • 1
0
votes
0 answers

SQL CE Compact Edition Toolbox OutOfMemoryException

I get OutOfMemoryException when i click Edit Top 200 Rows on a Table. I opened an 52,396 KB size sdf file. How can i open it? UPDATE: If i reopen the VS 2019 it works without problem. :)
Bence Végert
  • 728
  • 10
  • 12
0
votes
1 answer

"Add Linq-to-SQL Datacontext to Current Project" Disabled in SQL Server Compact

I'm trying to create Linq-to-sql DataContext using SQLite/SQL Server Compact Toolbox but I can't seem to drag the tables to the Linq-to-SQL file. So I tried to right click my table in the toolbox and the "Add Linq-to-SQL Datacontext to current…
Julio Motol
  • 763
  • 5
  • 22
0
votes
1 answer

SQL Server Compact Toolbox Won't Install with VS 2015

I download SqlCeToolbox.4.4.0.4.vsix and when I double clicked on it, nothing happened. So I put it in the %LocalAppData%\Microsoft\VisualStudio\14.0\Extnesions folder and it still won't work. I searched around, but couldn't find anything. Any ideas…
ernest
  • 1,633
  • 2
  • 30
  • 48
0
votes
0 answers

SQL Server CE deploying schema changes to the client .sdf file

I have never used SQL Server CE before, but I have a small project which would benefit from CE instead of full-blown SQL Server. Within Visual Studio I can create the DB schema which then generates an SDF file. I'm assuming that schema and data both…
Laurence Frost
  • 2,759
  • 3
  • 28
  • 45
0
votes
4 answers

Get SQLite to work with VS2013 Data Model Designer

I have followed very closely this great tutorial about how to connect SQLite with Visual Studio 2013, but when I get to the Entity Data Model Wizard part of the tutorial, I can't see my SQLite connection or the SQLite provider, there are only…
Michel Feinstein
  • 13,416
  • 16
  • 91
  • 173
0
votes
1 answer

Sql Server compact toolbox in VS 2013

I installed VS 2013 ultimate and Sql server compact 3.7.2 ,I opened my project but It seems that the SQlCe 3.5 link is grayed out and I can not open it and the other link of opening solution database causes an error and crashes VS . I do not want…
ali haider
  • 333
  • 3
  • 13
0
votes
1 answer

SQL Server Compact Toolbox Not Connecting to Databases

I am using SQL Server Compact Toolbox for runtime 3.5. When I select 'Add SQL Server Compact 3.5 Connection' I get what you can see in the following image. The problem is that after clicking 'Test Connection' and 'OK' nothing happens. The list on…
peter
  • 13,009
  • 22
  • 82
  • 142
0
votes
0 answers

SQL Server Compact Bulk Insert issue

I have a table created like this: And in my CSV file something like this: 34650326,Mr,John,Doe,Some Street Some City Some Country,33445566,77889900,jdoe@yahoo.com,120.33 For some reason the SQL bulk import from CSV will not do I though, keeps…
sd_dracula
  • 3,796
  • 28
  • 87
  • 158