migrating tables from Postgres to SQL Server 2008
We found a solution for this that ended up being super-fast: using a wizard in our ETL tool Pentaho Data Integration (Kettle).  Open a new job then Tools -> Wizard -> Copy Tables.  I wouldn't be surprised if other ETL tools had similar wizards.