× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



Mike,

Have you looked at the Generate Data Definition Language API? It can retrieve 
the DDL of a table, view, index, triggers, scheme (or library) in a source 
member and recreate it as well.

Ted Holt at IT Jungle wrote a utility for this API. Searching Google will give 
some hits.

The API is not that dif  ficult to use in a CLP, either.

I think passing a library name and objecy type SCHEME you can retrieve all the 
SQL commands to create it all, I think even with constraints and such.

Just a thought.

Regards,
Carel Teijgeler


*********** REPLY SEPARATOR  ***********

On 12-4-05 at 13:34 Mike Wills wrote:

>I know there was some discussion on this a week or two ago with David. We 
>are trying to create a duplicate SQL COLLECTION as a test DB. I know I can't 
>save and restore as a new name. So how would I go about copying all of the 
>data to the new DB? I have the tables setup, I just need to copy the data. 
>
>My vendor has a utility to do this, but it takes forever. It first creates a 
>dump of the DB (about a 17 GB file) onto the IFS, then they have me do an 
>import. Problem is this import ran for over 24 hours and wasn't complete 
>yet. I let it run over 36 hours before I cancelled it. That is not really 
>acceptable timeline for me. Plus you need to basically have three copies of 
>the DB on your server at once. That isn't exactly ideal when we have limited 
>amount of disk space.




As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.