Choose the source and target databases page

On this page, configure the following settings:

  1. Specify the SQL Server that hosts the database from which you’re importing data.

    NOTE: If your SQL Server is configured to accept connections on a non-standard port, add this port number after the server name, separating them with a comma; for example: SERVER001,5618.

  2. Provide your credentials to log in to the SQL Server. Your account must have the sysadmin role on the SQL Server. Sysadmin credentials are required only for creating a new database. Alloy Navigator will not use them later.

    • To log in using your Windows account, choose Windows Authentication. You are not required to type in a login and password.

    • To use your SQL Server account, choose SQL Server Authentication and enter your SQL login name and password.

  3. Choose the name of the source database.

  4. In the Target DB field, enter a name for the target (new) database.

  5. Choose a collation and database file settings (available only for the Create Pilot Database option):

    • To use the default collation and database file settings, leave the Configure advanced database properties (collation, storage, etc.) check box clear, click Next. Use this option if you’re not sure about those settings.

    • To choose a non-default collation for the database and/or change names, locations, or initial sizes for the database files, select the Configure advanced database properties (collation, storage, etc.) check box and click Next.