Builds SQL statements using the Query Builder feature or it can create new SQL server databases. Regarding tables, it can view data, delete data or insert data. Creates SQL Scripts or difference Scripts between two SQLCE databases for structure and data.
SDF Viewer is a smart and handy tool, good enough for database professionals, yet easy to use. SDF Viewer allows you to create, view and edit SQL Server Compact Edition (SQLCE) data.
Main Features:
- Runs on Windows XP (Service Pack 3), Vista, Windows 7, Windows 8
- Works with SQL Server CE Auto Detection of Database Versions
- Copies Database Files to and from your Windows Mobile Device
- Opens .SDF Database file on your PC
- Creates New SQL Server Compact Edition Databases
- View the Database and Index Structures
- Create a New Tables, Rename, Drop or Modify Existing Tables
- Add, Delete, Rename, Re-Order and Alter Data Columns
- Create New Indexes and Rename Existing Indexes
-Add Single and Multiple Foreign Key Relationships
- Rename Existing Relationships
- View, Sort, Add, Modify and Delete Data from Tables
- View, Add, Rename and Change Image Columns
- Create SQL Queries and Scripts, Drag & Drop Table and Column Names to Query
- Open/Save/Run Scripts/Queries as *.sqlce files
- Create Difference Scripts between two sqlce databases for structure and data
- Add, Change and Remove Database Passwords
- Compact and Repair Databases
- Upgrade Existing Databases to higher versions
- Import and Export Tables to Excel XLS and XML formats
- Import From SQL Server and SQL Server Express
- Import From MS Access
- Import Pictures into a Database
- Script SQLCE Database Tables, Data, Indexes
- Set an automatic backup of database files each time they are opened
Comments