We have several add-on applications that depend on third-party DDFs for our data connections.
Currently, we add our own tables, procedures, and functions etc. to extend this database.
Trouble comes when new DDFs are published and we need to update our connections.
I need to be able to dynamically move all of my own schema information and data into a new connection, using the newly published third-party DDFs.
I'm reasonably certain I can accomplish this by reading the additional (i.e. my own) table structures, and creating the tables in the new connection, and then moving the data over.
My question is this:
How can I get the entire, accurate, CREATE TABLE statements including indexes using Pervasive 9.6 for an existing table programmatically?
I know I can do this through PCC, and since the DTO objects seem to expose just about everything, surely there is a preferred way of doing this.
Guidance Btrieve guys, pour favor.
