Admin Console > Import or export with command prompt > Import or export a database using command prompt

Import or export a database using 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 command: 
    Altosoft.Insight.Import.exe
-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 Microsoft 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.Export.exe -h

  3. Execute the following command, listing all parameters in one line): 
     Altosoft.Insight.Export.exe
-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 Microsoft SQL server. Define user name, password, database provider and database.

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