When specifying connection string information using command line switches, the --datasourcename switch, the --connectionstring switch, and the --provider switch are required.
The --connectionstring switch specifies the connection string used to connect to the database. The connection string contains connection information for the database. For example, the following command contains connection string information used to connect to a database in a SQL Server environment:
--connectionstring "Data Source=Serv001\instance;database=TestDB; User Id=username;Password=password"
The parameters required for a connection string are different for SQL Server and Oracle environments.
-
For information on constructing connection strings for use with SQL Server, see SQL Server Connection String Parameters.
-
For information on constructing connection strings for use with Oracle, see Oracle Connection String Parameters.