Authentication

FastTransfer supports two types of authentication methods depending on your database platform.

Authentication Methods

1. Trusted Connection

Uses the current Windows user's credentials or the operating system authentication if allowed by the RDBMS.

.\\FastTransfer.exe ` 
...
 --trusted `
...

Syntax:

• Short form: -A
• Long form: --trusted

Warning

This method is only available if your RDBMS supports trusted/integrated authentication (e.g., SQL Server with Windows Authentication).

2. SQL Login with Username and Password

Standard database authentication with explicit credentials.

./FastTransfer `
...
 --user "myuser" `
 --password "mypassword" `
...

Syntax:

• Username: -U "username" or --user "username"
• Password: -X "password" or --password "password"

Alternative: Connection String Parameter

You can also use the --connectionstring parameter where you pass the user and password directly in the connection string. This parameter will be covered in detail in the Connection Parameters section.

Password Security in Logs

All passwords passed either through the --password parameter or within the --connectionstring parameter are automatically hidden in all logs (Console, Files, and Database). This ensures your credentials remain secure in logging outputs.

Tips

For Login/Password you can also use the environment variables like FastTransfer_USER and FastTransfer_PASSWORD for exemple or store the password in an encrypted file. Up to you to decrypt the file and it’s content before using it in a shell variable that will be used with FastTransfer.