• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 162
  • Last Modified:

Creating Database using parameters

Hi again

Does anybody knows how to retrive the information (parametes) of a database and save it to a text file, and then can use it to create anothher database whit the same characteristics...

Thanks
0
_JHL_
Asked:
_JHL_
1 Solution
 
Wim ten BrinkSelf-employed developerCommented:
This information is very database-dependant. You might be able to retrieve some generic database information by importing the type library in "C:\Program Files\Common Files\System\ADO\msadox.dll" or wherever your msadox.dll is located and then use these components to retrieve whatever information you need through ADO. It is especially useful to get table names, field names and types and several constraints but it won't generate a perfect copy.
For a perfect copy you need to use more database-specific solutions.
0
 
_JHL_Author Commented:
It´s too complicated, basically i want to make a re-ingeniering like the option used with MySql on MySqlAdmin....
Any idea, of how to do independent of the database, using SQL propably=?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now