Usage

Currently, there is only a console version of the program.

Run acopyconsole from the command line.

To get the parameter information below:

acopyconsole -?

Example:

To copy tables starting with the letter ‘a’,¬†from your C-drive into a local Sql Server database:

acopyconsole -RM -din -Dmydb -Umyusers -Pmypassword -Slocalhost -fc:\repository a%

 

Parameters:

[-?]
Display description of all command line arguments.

[-C<connection_string_name>]
A connection string name that exists in the app.config file. OBS: Not the connection string itself

[-D]
SQL Server only. If you want to connect to another database then the default for your Login, you have to use this parameter.

-P<password>
The password for the login (Sql Server) or user (Oracle)

-R{O|M}
The database provider you are running against, Oracle (O) or Microsoft SQL Server (M)

-S<server_name>
The name of the database server. E.g. myserver\instance for SQL Server, or myserver/orcl for Oracle. OBS: ODBC connection is not allowed.

-U<user_name>
The name of the the login (Sql Server) or user (Oracle)

[-b<batch_size>]
For copy in only (-din). Collects rows in a “batch”, and sends the batch to the server as one operation.
SQL Server: Default is 0 (zero), which means that we send for every row.
Oracle: Default is 10.000.

[-c]
The data files will be compressed using the Deflate algorithm.

-d{in|out}
The direction of the data flow. (in)to the database, or (out) from the database

[-e[<collation>]]
Sql Server only. Override the default database collation. If no collation is given, it will use the collation it finds in the datafile (the collation from the database it was copied from).

[-f<folder_name>]
The folder for the the data and schema files. If the folder doesn’t exist, it will be created. If -f is not used, the files reside in the current folder.

[-g<datafile_suffix>]
Default suffix for a datafile is ‘adata’, but you can set it to what you want. OBS: Remember to use the same value for copy in, as copy out

[-h<schema_file_suffix>]
Default suffix for a schema file is ‘aschema’, but you can set it to what you want. OBS: Remember to use the same value for copy in, as copy out

[-i]
A clustered index is created on the agrtid column.

[-m]
Limit the number of tables that will be read/written in parallel. Default is -1, which means there is no limit. You might want to set a limit when your data source is an SQL Azure database.

[-v]
The views found in asysview and aagview will be created. If the same view exists in both tables, the one in aagview will be created.