Sample Commands for MS SQL Server

This topic covers the sample commands to perform various tasks using the pdbctl utility such as adding database connection, creating user mapping, setting encryption properties, and migrating data.

1. Set the environment variable (PDB_MUTIL_PATH).

   • On Linux

     export PDB_MUTIL_PATH=<PATH OF UTILITY>

     Copy

   • On Windows

     set PDB_MUTIL_PATH=<PATH OF UTILITY>

     Copy

2. Add the database alias.
   Command used: adddb

   pdbctl.exe adddb -a <databaseuseralias> -t <Database Type> -u  <database user> -p <Database user password> -m <meta data password>  -d  <SID/databse name> -i <Host IP> -o <PORT>   -b <nae user> -c <naepassword>

   Copy

3. Add the user mapping to authorize an user.
   Command used: addusermap

   pdbctl.exe  addusermap -a <databaseuseralias> -d <databaseuser> -p <naepassword> -u <naeuser>

   Copy

4. Verify the user mapping.
   Command used: listusermap

   pdbctl.exe  listusermap -a <databaseuseralias>

   Copy

5. Set the encryption properties for a column.
   Command used: setencinfo

   pdbctl.exe setencinfo  -d <database_alias> -a <algorithm> -c <column_name>  -k <key_name> -m <mode> -t <table_name>

   Copy

6. View the list of columns.
   Command used: listcolumns

   pdbctl.exe  listcolumns -a <database_alias> -t <table_name>

   Copy

7. Migrate the table.
   Command used: migrate

   pdbctl.exe migrate  -a <database_alias> -t <table_name> --verbose

   Copy