Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Creating Database using parameters

Posted on 2003-10-21
4
Medium Priority
?
159 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 200 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

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

Question has a verified solution.

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

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 I have seen many questions in this Delphi topic area where queries in threads are needed or suggested. I know bumped into a similar need. This article will address some of the concepts when dealing with a multithreaded delphi database…
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…
Suggested Courses

688 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