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.
Data dictionary - any builin functions
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
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.
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.