Re: ANN: AnySQL Maestro (freeware cross-database tool)

Vadim Vinokur has brought this to us :
AnySQL Maestro operates via ADO. It calls OpenSchema to retrieve metadata, see
http://www.w3schools.com/ado/met_conn_openschema.asp

There is no way to extract view/procedure/trigger bodies, manage users, grants, etc. Also OpenSchema knows nothing about DBMS specific objects, such as tablespaces, jobs, partitions, full-text catalogs, etc.

Also AnySQL Maestro strongly depends from OLE DB Provider / ODBC Driver you have installed. Some providers even do not return indexes and/or foreign keys. Check constraints are not returned correctly by any driver/provider.

Do you have a product like AnySQL where I can connect to a variety of database vendors and have full database management? I would like to avoid loading a dedicated tool for each database system I use.


.

Relevant Pages

  • Re: OpenSchema with DSN less connection
    ... >OpenSchema works correctly....I would have thought that the OLE DB ... >Provider would be more likely to work than the ODBC driver (obviously ...
    (borland.public.delphi.database.ado)
  • Re: MS Oracle Data Provider BUG: Data corrupt after 16 rows with O
    ... Could you use this to check the data in your database? ... Once you have done this with both the Oracle managed provider and either ... imported into the 9i database without any errors (i tried 8i Client as well ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: application design problem
    ... Actual action is depends on your Provider which provide service for a particual database or data store. ... When I would click Button1 this sql would execute: ... I dont think its a good idea to put all your client spcific logic ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Process wont die when form is closed.
    ... The database is a Pervasive v.9 with an ODBC driver. ... The DataGridView works great except when I'm done and I click the X to close ... Or is the background thread just an automagic thing and I have to insert the IsBackground property somewhere in order for the code to shutdown properly? ... In this case it means that the code is stucked in the main thread, probably in the Pervasive ODBC driver. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Process wont die when form is closed.
    ... The database is a Pervasive v.9 with an ODBC driver. ... The DataGridView works great except when I'm done and I click the X to ... and what he is waiting for. ... None of these threads are the application's UI thread, nor are they CLR threads, so my guess is that they come from a buggy ODBC driver. ...
    (microsoft.public.dotnet.languages.csharp)