The database administrator tool
The database administrator tool. The designation:
Study the structure of the database, viewing objects.
- Loading - loading data from the tables taking into account the connections between them
- cleaning the database tables taking into account the connections between them
- Editing stored procedures, views and triggers
Implementation of SQL requests
- for MS SQLServer 2005 and above - Command Tracking (Profile)
Access to the databases is made through the ADO interface.
Set up to a specific SUBD (SQL Server, Informix, Sybase Anywhere, MS Access).
Made in Delphi. I use this task to verify the possibilities of the programming tool.
Therefore there are analogues for D2 (juno, DFL), Windows Mobile (C#), Oberon (XDS, ODBC, WinAPI), Modula 3 (CM3, ODBC, WinAPI), Lua (luacom, IUP) and HTML (MSIE).
Study the structure of the database, viewing objects.
- Loading - loading data from the tables taking into account the connections between them
- cleaning the database tables taking into account the connections between them
- Editing stored procedures, views and triggers
Implementation of SQL requests
- for MS SQLServer 2005 and above - Command Tracking (Profile)
Access to the databases is made through the ADO interface.
Set up to a specific SUBD (SQL Server, Informix, Sybase Anywhere, MS Access).
Made in Delphi. I use this task to verify the possibilities of the programming tool.
Therefore there are analogues for D2 (juno, DFL), Windows Mobile (C#), Oberon (XDS, ODBC, WinAPI), Modula 3 (CM3, ODBC, WinAPI), Lua (luacom, IUP) and HTML (MSIE).