Admin Console > Import or export via command prompt > Import or export a database via command prompt

Import or export a database via command prompt

Import a database

You can import a database through a command prompt.

  1. Create an empty database on the SQL server.
  2. Execute the following: 
    Altosoft.Insight.ImportExport.EntryPoint.exe
-import -path="C:\ImportExport\ExportDB_TestBundle_data"
-connection="Data Source=<server name>;Initial Catalog=ImportDBtest;
User Id=<User ID>;Password=<password>;" -provider="sql" -dbType="MS SQL
Server" -login=Administrator -pwd=1234
  3. Define the connection strings.

    Note In the sample above, the command is shown for MS SQL Server. Define the user name, password, database provider, and database.

  4. Execute the command.

    The new database contains the imported data.

Export a database

You can export a database through a command prompt.
  1. Create a folder where the database will be exported.
  2. Open Help to list all available commands: 

    Altosoft.Insight.ImportExport.EntryPoint.exe -h

  3. Execute the following (all parameters must be listed in one line): 
     Altosoft.Insight.ImportExport.EntryPoint.exe
-export -path="C:\ImportExport\ExportDB_TestBundle_data"
-connection="Data Source=<server name>;Initial
Catalog=TestBundle_data; User Id=<User ID>;Password=<password>;" -provider="sql"
-dbType="MS SQL Server"
  4. Define the connection strings.
    Note In the sample above the command is shown for the MS SQL server. Define user name, password, database provider and database.

    All the data is exported to the specified directory in XML files.