Solved

Creating Database using parameters

Posted on 2003-10-21
4
152 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_
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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

This article explains how to create forms/units independent of other forms/units object names in a delphi project. Have you ever created a form for user input in a Delphi project and then had the need to have that same form in a other Delphi proj…
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…
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.

932 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now