Solved

Creating Database using parameters

Posted on 2003-10-21
4
155 Views
Last Modified: 2010-04-05
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
Comment
Question by:_JHL_
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
4 Comments
 
LVL 17

Accepted Solution

by:
Wim ten Brink earned 50 total points
ID: 9598441
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
 

Author Comment

by:_JHL_
ID: 9606057
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

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Working with hours 3 74
Dev Express grid collapse 2 47
Wincontrol not (correctly) drawn 15 47
How to save the image in the .cds File ClientDataSet? 1 30
A lot of questions regard threads in Delphi.   One of the more specific questions is how to show progress of the thread.   Updating a progressbar from inside a thread is a mistake. A solution to this would be to send a synchronized message to the…
Introduction Raise your hands if you were as upset with FireMonkey as I was when I discovered that there was no TListview.  I use TListView in almost all of my applications I've written, and I was not going to compromise by resorting to TStringGrid…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

749 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question