Questions tagged [sql-server-compact]
SQL Server Compact Edition
29
questions
0
votes
2
answers
550
views
Skip one row inside request using inner join (sql compact server 4.0)
I am using SQL server compact 4.0 and VB.net and Visual studio 2019.
I am using this request to extract information from 4 tables : Table0, Table1, Table2 and Table3.
This request is working fine ...
- 3
1
vote
0
answers
2k
views
Ok to remove SQL Server Compact 3.5 from a SQL 2008 R2 Server?
We still have one production SQL 2008 R2 Server. Yes, there are plans to upgrade soon, just not immediately. In the meantime, our Vulnerability reports are flagging the server as vulnerable because ...
- 111
0
votes
1
answer
141
views
Is the subscription of merge replication only for SQL Server Compact Edition?
While creating a publication I saw this
Does this mean the subscribers can't be other editions of SQL Server but Compact?
Do other editions need to use Peer-to-Peer replication instead?
Thanks
- 2,142
0
votes
1
answer
582
views
How to convert a Microsoft SQL Server CE file (.sdf) to Postgres 9.6 /pgAdmin 4?
I have a database file data.sdf that I want to import into PgAdmin 4. I've considered using pgloader but the file format does not seem to be accepted. Does anybody have any hints on how I might go ...
0
votes
1
answer
602
views
Storing a json string that is 10 kb in size in a SQL Server CE cell
I have a SQL Server CE database in which I have column that takes values of json strings. These json strings are above 9kb as a result of which I am unable to use varchar or char. I guess I could ...
- 471
0
votes
1
answer
128
views
Can you Mirror an Microsoft SQL compact Edition database
We have a PLC inputting summary data into a Microsoft Compact SQlce Edition database. We would like to run queries to on this data, but are unable due to the type of database it is, compact. It, as ...
- 103
3
votes
2
answers
799
views
How can I re-index a column using SQL Server Compact Edition?
We have a table TemplateItem that has a column ListIndex that stores the order in which we want the items to show in the UI. This table is self-referencing / hierarchical.
The query requirement is ...
- 131
1
vote
1
answer
134
views
How to get SQL Server Compact 4.0 Database content query?
I need to migrate data to a SQL Server 2014 database from an existing SQL Server CE 4.0 database. I'm having difficulty because my computer runs SQL Server 2012 so I'm not able to port the data via a ...
- 131
0
votes
2
answers
106
views
Added a unique index, but cannot find it in TABLE_CONSTRAINTS
I'm running the following command in my DB:
CREATE UNIQUE INDEX [UK_NAME1] ON [TABLE1] ([COLUMN1] ASC);
Now, I'm running the following query:
SELECT * FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS
And ...
- 117
0
votes
1
answer
74
views
Locking the database to a single user so that other user wont change it
I am using SQL Server CE 4.0. In office the database (.sdf) file are on a server. When I want to change design of the database I have to copy it to local PC and access it since n/w connection to a ...
- 3,131
-1
votes
1
answer
731
views
SQL Server CE tools to modify database in network share
I am using SQL Server CE 4.0 SP1. I am using Web Developer 2010 Express to connect to database and perform operations like creating table, modifying column etc. But we cannot connect a database in a ...
- 3,131
2
votes
1
answer
99
views
Index that mimics full-text-index
I have a database that is retrieving information quite slowly, I asked a question and was told to use full-text-indexing, this worked, but now we switched over to a .sdf file and Sql Server Compact ...
- 133
0
votes
1
answer
2k
views
SQL Server CE 4.0 network share access
In our application we are planning to use SQL Server CE 4.0 using OLE DB. The connection string is shown below.
Dim strConn As String = "Provider=Microsoft.SQLSERVER.CE.OLEDB.4.0;Data Source=\\pc137\...
- 3,131
0
votes
3
answers
378
views
SQL Server Compact - Will it perform well with heavier traffic sites? [closed]
I'm using Orchard CMS, and on initial setup, the default setting is to use SQL Server Compact. I'm not too knowledgeable about different database types and performance.
So, will SQL Server Compact be ...
- 103
1
vote
1
answer
840
views
Resolving Cyclical Reference in Referential Relationships
I'm designing a small SQL Server Compact Edition database and am attempting to enforce referential integrity. The database is a simple backend for a small desktop application that functions as an ...
- 113
1
vote
0
answers
67
views
Will installing WebMatrix (and Consequently SQL Server CE) Break My Current Installation of SQL Server 2005?
We have a server that has (and needs to keep) SQL Server 2005.
We are hosting intranet sites on one server (server 1), but have a database on another server (server 2). One of these sites uses AJAX ...
- 165
0
votes
2
answers
1k
views
SQL Server compact- Query that return 2 constant columns even if query didn't return data
Please look at the following simple query:
Select CustomerID
From Customers c
Where c.CustomerId = "1234"
I want to write similar query that does the following:
Always return 2 columns with ...
- 13
1
vote
1
answer
361
views
How to write this query in SQL Server Compact in more elegant way?
The query is :
Select
Case AStatus
When 1 then 'Success'
When 0 then 'Faliure'
END,
Case AStatus
When 1 then 'AStatus'
...
- 13
5
votes
2
answers
35k
views
How do I view a Microsoft SQL Server Compact Database
I have installed SQL Server 2012 Enterprise Edition.
I can use SQL Server Data Tools to add databases and tables and query tables etc.
Next, I used Visual Studio to try out a tutorial on creating a ...
- 161
3
votes
0
answers
267
views
How can I search values, considering occurences, on more than one term in SQL Server CE?
I have a rather complex SQL query, that I actually received help from this SE site to come up with parts of. This query is designed to take a search term and search all relevant values in a database (...
- 165
2
votes
2
answers
2k
views
Is there any way to tell the number of matches found in a database value matched with LIKE?
Is there any way I can query a SQL-Server-CE database that will return the number of matches found in a cell value using LIKE (or MATCH AGAINST or any other method I'm not aware of, really)?
EXAMPLE ...
- 165
4
votes
0
answers
304
views
merge replication too big
I have multiple handhelds which sync their data via merge replication. From time to time, new core data is imported on the server-database.
For various reasons I keep the old data in the databse and ...
- 183
1
vote
0
answers
2k
views
How to backup a running SQL Server CE database with full data?
I need to move my running windows-based app (built in C#) to another machine, but I also need to transfer the whole data, how can I take a backup from the .sdf file and use it with the new installed ...
1
vote
1
answer
702
views
Broken SELECT in Sql Server Compact 3.5 SP2?
I'm looking for a cause of a really strange case of SQL Server Compact db corruption. The case is that in a .NET Compact Framework app that we are running every once in a while we get into a situation ...
1
vote
2
answers
2k
views
Options for keeping two SQL Server Compact databases in sync?
Developer here. I have a system where there is a front machine creating rows in a moderately complex database, and a back machine that must sync with the front machine to run reports. Both run SQL ...
- 129
4
votes
2
answers
723
views
Many to Many Relationship Question
I have a database, with one main table: Project, and about 10 other tables (Entity1, Entity2, etc.)
Each of the different entities can belong to one or many projects.
I know I can have tables like ...
- 147
2
votes
1
answer
755
views
How does merge replication work with SQL Server CE
I have been trying out merge replication with SQL Server databases, and was just wondering how merge replication works on SQL Server CE?
For instance merge replication with SQL Server databases ...
- 2,187
4
votes
1
answer
3k
views
How does performance of SQL Server CE and SQL Server Express compare?
We have an application that runs on netbooks. It currently uses a SQL Server CE 3.5 database, and we are thinking of upgrading to SQL Server Express.
Just wonder if there are any benchmarks to ...
- 2,187
6
votes
1
answer
290
views
32-bit or 64-bit for development and deployment?
I'm creating a Windows desktop application and want to include a database. I've chosen SQL Server Compact 4 but when I download it there are two versions (32-bit and 64-bit). My development machine is ...
- 163