Stack Overflow
Stack Overflow

Questions tagged [compact-database]

70 questions
1
vote
1 answer

Synchronization two SQL Server databases without link beetween

I have central SQL Server 2008 Enterprise database and many clients with SQL Server 2008 Express databases. And I have a task for synchronization between central database and client's databases: download sales data from clients and load into server…
viko
  • 61
  • 3
1
vote
2 answers

Is it possible to compact an embedded HSQL DB from a Spring Boot application?

I've created a Spring Boot application with an embedded, file-based HSQL database. The data file being created is getting fairly large, especially given the usage model, so I'm wondering if there is a way it can be compacted? Either manually or…
Thinking Inside Your Box
  • 21
  • 4
1
vote
2 answers

Reading .dbf files using .NET Compact Framework on Windows Mobile Devices

I want to read .dbf file on Windows Mobile 5.0 device (Windows CE based devices in general). Basically, I need to convert .dbf file to .sdf file & then use .sdf in my application. The only reason for this conversion requirement is the size of the…
Mehul Patel
  • 11
  • 6
1
vote
2 answers

Why do MS Access front-ends increase in size over time?

I have an MS Access front-end (Oracle back-end) that has 2 linked tables, 2 MS Access queries, and 4 reports. I've noticed that the .accdb files (stored on users' desktops) get bigger over time. They start out at under 1mb after a compact, and end…
User1974
  • 276
  • 1
  • 17
  • 63
1
vote
1 answer

Problem in compacting Access 2007 Database, After Compacting Access 2007 Database gets converted to Access 2002-2003 format

I am using a Delphi procedure to Compact Access Database Code sniphet of procedure is: procedure CompactDatabase(pFullDatabasePathName : string; pLoginName : string = ''; pPassword : string = ''; pSystemDb : string = ''); var JE :…
Nains
  • 258
  • 2
  • 15
1
vote
1 answer

Synchronizing the database failed with the message 'string truncation...'

Using N-Tier synchronization to a Microsoft Compact DB: http://msdn.microsoft.com/en-us/library/bb882690.aspx. Trying to refresh the local database cache to account for changes in the schema of the db we are syncing against. In the middle of…
Benjamin
  • 131
  • 1
  • 6
1
vote
1 answer

how to check and alter constraints

hi can anyone tel me how to check whether a primary key exists or not in a table and add a primary key if not exixts in sql server compact(.sdf).. i'm using this, IF NOT EXISTS(SELECT * FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS WHERE…
Leema
  • 97
  • 3
  • 13
1
vote
2 answers

PouchDB compaction has no affect on db size on disk

I make use of couchdb/pouchdb to replicate data from a server down to a mobile device (data is only replicated downstream to the mobile device). As my dataset is large (approx 100,000 documents) i'm try to use the compact feature in pouchdb to…
Andrew Thomson
  • 4,572
  • 3
  • 18
  • 15
1
vote
2 answers

Use sdf database(SQL Server Compact 3.5 database file) without installing Microsoft sql server C#

I want to use a database in my C# program but I don't want other users who want to use my program to have to install a big volume software like Microsoft SQL Server that is more than 2 GB. So, can I use .sdf database (SQL Server Compact 3.5)…
SoheilYou
  • 907
  • 5
  • 23
  • 43
1
vote
1 answer

What does Mongodb's compact actually do?

Well, probably this should be clear from the documentation, sadly, this is not the case. My guess was, that compact make some kind of defragmentation of the colection - such that collection's paddingfactor would go bellow given value. However, this…
Tomas Kulich
  • 14,388
  • 4
  • 30
  • 35
1
vote
1 answer

Best Option for embedded databases using .Net 4.0/4.5

Does anyone know the best option for embedded databases using .Net 4.0/4.5 The application is targeting Windows. I have been using SQLite for my project for years. However, technology has changed quite a bit since .Net 2.0. I am upgrading my project…
Michael Hartmann
  • 574
  • 7
  • 24
1
vote
1 answer

Compacting an Access 2003 database in VB.NET via DAO

Actually I am using the next code to compact Access 2003 databases (mdb files). in the past, I've used JRO.JetEngine (but is obsolete). code: Add Reference: Microsoft Office 12.0 Access Database Engine Object Library Dim AccessEngine As New…
kontable
  • 73
  • 9
1
vote
3 answers

You are trying to access an older version of a SQL Server Compact Edition database

I am getting error when I am trying to open connection. My DB.sdf file is in my application folder here i stored db.sdf { string ConnectionString= new System.IO.FileInfo(System.Reflection.Assembly.GetExecutingAssembly().Location).DirectoryName +…
Raam
  • 11
  • 1
  • 3
1
vote
0 answers

Problems creating a compact database based on database first model / Nullable cousing errors

I am using ef database first to create my entity classes. Now I would like to create a compact database from these entity classes but everytime I try to query the compact database (what should create the db becvause it does not exist so far) I get…
Shatterator
  • 51
  • 1
  • 4
1
vote
1 answer

C# Windows Form App (Private deployment of SQL Server Compact 3.5 SP2) Error - Stopped working

This is my 1st time deploying a C# project. dev machine x64 targeted machine x86 Setup Project Launch Condition .NET Framework 4 According to http://erikej.blogspot.com/2012/05/private-deployment-of-sql-server.html applications targeting .NET…
user2994921
  • 89
  • 1
  • 14
1
2
3 4 5