Jennifer_Jinhong_34

DB Connection String Syntax for ARA Utilities (Data Migrator, DB Cleanup)

Discussion created by Jennifer_Jinhong_34 on Mar 2, 2016
Latest reply on Dec 13, 2016 by Duong_Nguyen-Nhat_2335
Couldn't find an example in the documentation for the syntax of the Connection String and in previous versions the default value was an example of the syntax.

So here it is for easy reference:

Data Source=##DB SERVER##;Initial Catalog=##DB                               NAME##;User ID=##DB USER##;Password=##DB PASSWORD##

Parameters:

               
  • Data Source: Replace  ##DB SERVER## with your database                                         server name, to which you have connected
  • Initial Catalog: Replace  ##DB NAME## with your database                                         name (e.g., ARA)
  • User                                         ID: Replace  ##DB USER## with your database                                         user
  • Password: Replace ##DB PASSWORD## with your                                         database user password

Example:

Data Source=MyServert;Initial Catalog=ara;User                                         ID=automic;Password=myPassword



Outcomes