DNA User Guide › File Menu › Save to Database

Save to Database

If a database was opened using the Open from Database option and changes were made on the production server, the modified files can be saved to the production server using this option.

To save to a database

1. Click File, Save to Database.

   The Database Wizard opens.

2. Fill in the following information in the Database Wizard window.

   Type

   Specifies the type of database data that you are downloading.

   Server

   Defines the remote server's IP address.

   Database

   Defines the database file name on the remote computer

   Windows Authentication

   Select this option to access the MS SQL server using the current user's Username and Password that is associated with Windows operating system.

   Overwrite Database if Exists

   Select this option to overwrite a database with the same name, if such as database already exists on the database server.

   User Name, Password

   Defines credentials to access the database host

   Use BULK INSERT

   Select this option to write data to a SQL readable temporary file. This speeds up the save process.

   Note: Using this option requires the SQL server to have read-access to a Shared folder in which the temporary file is stored during the save process. For more information see Configure Bulk Insertion of SQL Data.

3. Click Next to continue to the next screen of the wizard.
4. Save to an existing configuration or save to a new configuration.
5. Click Next to finish.