Not sure if Discussion is correct place for this question about a possible new tool, but:
Not sure if Discussion is correct place for this question about a possible new tool, but:
Do there exist some program that may extract metadata structur of the components involved in communicating with an Oracle database consisting of tables and lots of stored procedures in packages?
Writing a TCP/IP based multitier Datasnap DBExpress Datasnap server, coupled up to an Oracle Database server still under development, I need a tool for quality check of all parts of the system now and then.
It is easy to make a meta-data export of the database model with ER/Studio, but, for the server, metadata extraction only exists for the client when making the proxy datastructure and not to be exported to Excel/CVS file.
I need a tool to produce an excel spreed sheet or CVS file with export of tje tSQLdataset properties of Name of component, commandtext, CommandType, SchemaName, maybe SQLConnection in case more than one is defined and serialized parameter list and for tStoredProc I need the equivalents, expecially the parameter list.
By sorting these I would hope to be able to combine with a metadata export from ER/STudio to quality test that tables in model to have an equicalent tSQLDataset defined, and if a tSQLdataset still has the equivalent defined in the database model, in case the table or stored procedure is removed generating an error if accidently still used in client.
Having at moment about 124 tables defined, 949 attributes, 23 views and 153 relationships defined in logical view and in addition about 150 stored procedures who mainly check if the record exists and if not, generate a sequence number and store a record with sequence number for identification and storing the keys needed to refind the record, and then let the client do an update to the record by fetching the new (or old record if already existing) for update to recent values calculated by the client.
Such an extraction program would increase the speed of quality checking, and visualize need of which stored procedyre need updating the parameters
Would be nice if the program also could do a merge-search on both dataset to show differences :-)
I guess this would be a tool of interest to many.
Hope it is of interest and that such a tool already exists?
Working alone with everything I don't have so much time for developing such a tool. Time is mostly used for the main system development, from specifications (the people I work for cannot decide exactly what they want, new requierments each time; and database design to ready clients for data harvesting (fired up by domain server at login, gathering some quality checks of computerr) and consumed by site admins or research group leaders either on PC, Mac or mobiles
#delphi #metadata #compare #erstudio
Do there exist some program that may extract metadata structur of the components involved in communicating with an Oracle database consisting of tables and lots of stored procedures in packages?
Writing a TCP/IP based multitier Datasnap DBExpress Datasnap server, coupled up to an Oracle Database server still under development, I need a tool for quality check of all parts of the system now and then.
It is easy to make a meta-data export of the database model with ER/Studio, but, for the server, metadata extraction only exists for the client when making the proxy datastructure and not to be exported to Excel/CVS file.
I need a tool to produce an excel spreed sheet or CVS file with export of tje tSQLdataset properties of Name of component, commandtext, CommandType, SchemaName, maybe SQLConnection in case more than one is defined and serialized parameter list and for tStoredProc I need the equivalents, expecially the parameter list.
By sorting these I would hope to be able to combine with a metadata export from ER/STudio to quality test that tables in model to have an equicalent tSQLDataset defined, and if a tSQLdataset still has the equivalent defined in the database model, in case the table or stored procedure is removed generating an error if accidently still used in client.
Having at moment about 124 tables defined, 949 attributes, 23 views and 153 relationships defined in logical view and in addition about 150 stored procedures who mainly check if the record exists and if not, generate a sequence number and store a record with sequence number for identification and storing the keys needed to refind the record, and then let the client do an update to the record by fetching the new (or old record if already existing) for update to recent values calculated by the client.
Such an extraction program would increase the speed of quality checking, and visualize need of which stored procedyre need updating the parameters
Would be nice if the program also could do a merge-search on both dataset to show differences :-)
I guess this would be a tool of interest to many.
Hope it is of interest and that such a tool already exists?
Working alone with everything I don't have so much time for developing such a tool. Time is mostly used for the main system development, from specifications (the people I work for cannot decide exactly what they want, new requierments each time; and database design to ready clients for data harvesting (fired up by domain server at login, gathering some quality checks of computerr) and consumed by site admins or research group leaders either on PC, Mac or mobiles
#delphi #metadata #compare #erstudio
Comments
Post a Comment