Let's Know More About Different Database Tools
Tools are necessary for database work. The first tool is Delphi itself. Secondly it is Database Desktop, by means of which it is possible to create a table and to set its properties. SQL Explorer is the next Database tool, which allows to look through the data in tables, both successively, and selective.
SQL Monitor allows considering in details the fulfillment of our inquiries to ODBC. You can take advantage of ODBC during the connection in MS SQL Server. And, at last, BDE Administrator and DataPump are also necessary, in spite of the seldom use.
Database Desktop is a program, by means of which you can create tables Paradox and also to change their structure in a consequence. In general, Database Desktop is applied not only for this purpose, but also for everything under the order.
SQL Explorer is the most universal and often used tool at work with database. With its help it is possible not only to create pseudonyms of a database, but also to look through them and, if necessary, to edit their contents. In window SQL Explorer the main menu, the tool panel and two working fields are located -the left with bookmarks Database and Dictionary and the right with bookmarks Definition, Data and Enter SQL.
The main menu and the tool panel serve for management of the utility and its adjustment. The left field in display mode of Database allows looking through already created pseudonyms and to create new, to edit and destroy them. It is possible to see the Database structure connected with a concrete pseudonym: tables entering into it, domains, representations, etc.
By means of SQL Explorer it is possible to create new Database pseudonyms, to change their parameters and to destroy them. However unlike BDE Administrator, utility SQL Explorer cannot change the properties of all identical pseudonyms or to make whole system installations of formats.
BDE Administrator is intended for creation of database pseudonyms and adjustment of their properties. You will need them seldom, because usually you have to use them one or two times for the project.
DataPump is useful for carry of a plenty of data from one source to another. You can modernize your project, and then you should not lose the turned out data. In this case DataPump will be useful to you. Its interface is rather simple and clear.
Terms And Conditions Privacy Contact Us Resources
|