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>
     

   • On Windows

         set PDB_MUTIL_PATH=<PATH OF UTILITY>
     

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>
   

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

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

4. Verify the user mapping.
   Command used: listusermap

       pdbctl.exe  listusermap -a <databaseuseralias>
   

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>
   

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

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

7. Migrate the table.
   Command used: migrate

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