Devart Forums

Are there any built in functions i UniDAC for creating a data dictionary.
And if a data dictionary is available is there any functions for creating the db.

Hello

Please explain what does it mean: data dictionary. Also please specify the database that you are using.

It is an easy way to have a complete description of a database and a method for creating the complete database on a new server or location.
It can be done by creating SQL dumps but for a new customer it might not be easy to create the new db.
For the time being I use both MySQL and MS SQL as database

- when I use SQLite or MS Access I include an empty db in the .exe file so a new setup is quite easy. And I have methods for updating existing tables using UniScript

To solve the problem you can connect to SQL server without specifying the Database property of TUniConnection. Then create a database using the 'CREATE DATABASE' statement, like this:
UniConnection.ExecSQL('CREATE DATABASE database_name', []);
After this you can use the TUniDump or TUniScript component to restore a database or its parts from a script.