Čeština
English
Create and manage your database model in WEB interface!
Articles
Creating database models
Thu, 11/17/2011 - 22:05 — adminData models in DatAdmin look like normal database. You can use the same tools to define data models as when working with real databases. Browsing database tree, defining tables, even defining static data in data models, all these jobs are performed in the some way. Also you are able to compare and synchronize data model with a real database.
Connection to MySQL on webhosting behind firewall
Thu, 11/10/2011 - 16:57 — adminDatAdmin supports a big variety of database connection methods. On of the most suprising is ability to connect to MySQL behind a firewall. This is a perfect solution for people which must use phpMyAdmin, because their webhoster doesn't allow direct connection to a database server.
Creating a database with DatAdmin
Fri, 11/04/2011 - 00:21 — adminDatAdmin database tool is suitable for creating small databases, eg. if you want to manage books of your library or make list of your music compact disks. I will show, how to easily create a database representing your library.
Import table data from HTML
Thu, 10/27/2011 - 18:03 — adminThis article describes a solution of common problem - we have a HTML file with some data, which should be imported into a database. This task can be acomplished using import from text file feature of DatAdmin database administration tool.
Problem definition
For demostration purposes, we want to import the following table (arrivals at airport web page):
Export BLOB fields
Sun, 10/23/2011 - 22:57 — adminThis article describes a new amazing feature of DatAdmin 5.2.7 version, export of BLOB fields. You can use this feature, if you want to export the BLOB fields from a table (or query result), for each row of the source table is created a separate file. The exporter is very easy to use, if you know, where to find it...
Keyboard shortcuts
Sat, 10/22/2011 - 11:42 — adminThis article contains a list of some keyboard shortcuts of DatAdmin database administration tool
How to generate CRL installation script
Thu, 10/20/2011 - 20:50 — adminThis article descibes solution of common situation, when you have CLR assembly (.NET DLL file), which you need to install into Microsoft SQL Server (CLR is supported from Microsoft 2005). You can use either deploy function of Microsoft Visual Studio or DACI command-line interface of DatAdmin database administration tool.
Using drag & drop database management tasks
Mon, 10/17/2011 - 20:16 — adminDatAdmin supports a big variety of drag & drop operations, you can use it for different database administration tasks. This overview shows most common use cases.
You can use drag & drop for:
SQLite - easy database without database server
Thu, 07/14/2011 - 13:22 — adminThis article describes, how to work with SQL database, if you don't have any database server. Everything you need, is installation of DatAdmin Personal (free edition). DatAdmin has support for embedded database engines SQLite and EffiProz.
Connection to Oracle
Thu, 07/14/2011 - 12:28 — adminDatAdmin supports connecting to Oracle using ODBC, OLE DB or native client. In all cases, you can use Oracle specific features.
