How to transfer multiple databases by sql-sync? I've created proper aliases and successfully pulled files/database from live to dev server by:

drush sql-sync @live @dev


But I noticed my secondary database (defined also in settings.php and in alias file) has not been populated when syncing. I have default database and one additional database for some special operations which I use.

There was no any error message after sync, so I presume drush did not try to copy that database.

Is there any additional procedure I must follow when doing sync of 2 databases, or this was presumed to be automatic?

If there is no out-of-the-box answer, or I should show my config files?
Drush sql-sync will only copy one database per run; if you have multiple databases to copy, you must run sql-sync multiple times.  Use --source-database=other and --target-database=other to specify some other database.  Use --source-target=mirror and --target-target=mirror if you want to copy a secondary mirror of your Drupal database (not your use-case).

Rename 'other' and 'mirror' to match the appropriate key of your database record.  See figure below.

Array
(
    [default] =&gt; Array
        (
            [default] =&gt; Array
                (
                    [driver] =&gt; mysql
                    [username] =&gt; www-data
                    [host] =&gt; localhost
                    [database] =&gt; drupaldb
                )
            [mirror] =&gt; Array
                (
                    [driver] =&gt; mysql
                    [username] =&gt; www-data
                    [host] =&gt; localhost
                    [database] =&gt; mirrordrupaldb
                )

        )
    [other] =&gt; Array
        (
            [default] =&gt; Array
                (
                    [driver] =&gt; mysql
                    [username] =&gt; www-data
                    [host] =&gt; localhost
                    [database] =&gt; otherdb
                )

        )

)


Update from NenadP:

It seems that you need to add --strict=0 when using Drush 5 to work around a bug in the sql-sync command definition.  This has been fixed in Drush 8.6-6.x.