SQL Server Datenbanken – Ersatz für Stonefield Data Dictionary
Viele von uns haben ja bereits ihre Anwendung auch mit SQL-Server-Datenbanken am laufen. In diesem Fall hat man aber das Problem bei der Verteilung der Anwendung vor Ort die Datenbankstrukturen aktuell zu halten. Unter FoxPro konnte man dafür ja Stonefield Data Dictionary einsetzen was aber mit SQL-Server nicht mehr funktionert.
Ein Ersatz hierfür gibt es aber, welcher einem auch die Bereitstellung von entsprechenden Installationsscripts massiv erleichtert:
SQL Packager™
Latest version: 5.5
Packages a database or a database update
- Script your entire database accurately and quickly
- Move your database from A to B
- Compress your database as a .exe, or launch as a Visual Studio project
- Simplify database deployments and installations – SQL Server 2000, 2005 and 2008
- Easy roll-out of database application updates across your client base
“SQL Packager is one of the most useful tools I have ever seen. The ability to package the database schema and data of preconfigured lookup tables is great. I have tested it using one of our customer databases and it works fine. The new database has been installed correctly on the new server” Thomas Stensitzki, iComCept GmbH
Walk-through
View our short screen-by-screen introductory walk-through
Demo video
Step-by-step demo of SQL Packager in action
Standard Edition €245
Packages a database or a database update.
Pro Edition €395
SQL Packager Pro offers access to the command line interface.
With SQL Packager Pro, you can package a database or a database update, as well as automate tasks, thanks to the incorporated command-line interface.
SQL Packager works by scripting and compressing the entire database – schema and data together – and packaging it up as a deliverable .exe file. It does this by scripting separate transactions for schema and data respectively.
When migrating databases, all schema objects, all new tables and their data as well as data with unique indexes or constraints are also scripted.
Installing, updating, or distributing your database now becomes a simple point-and-click procedure. Deploy SQL Server 2005 databases, and applications that depend on them, with no manual scripting!
By letting you compress your packaged database, you can reduce storage overhead and distribute it faster and more easily. SQL Packager also makes it easy to archive your database, and is an excellent solution for making a backup of your database where you don’t have SQL Server administration rights.
You can read how iCOMcept in Aachen, Germany, minimized their application deployment window using SQL Packager.