Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Creating Database using parameters

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

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

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…
In my programming career I have only very rarely run into situations where operator overloading would be of any use in my work.  Normally those situations involved math with either overly large numbers (hundreds of thousands of digits or accuracy re…
This Micro Tutorial will teach you how to add a cinematic look to any film or video out there. There are very few simple steps that you will follow to do so. This will be demonstrated using Adobe Premiere Pro CS6.
In response to a need for security and privacy, and to continue fostering an environment members can turn to for support, solutions, and education, Experts Exchange has created anonymous question capabilities. This new feature is available to our Pr…

885 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