Based on Greg Anderson's chapter in the Definitive Guide to Drupal 7.
drush sql-sync @dgd7.prod @dgd7.local
Prerequisites
A dgd7.aliases.drushrc.php file in a ~/.drush directory (that's a .drush folder in your home directory) that contains something like:
Except where otherwise noted, content on this site is licensed under a Creative Commons Attribution 3.0 Unported License.