Copy tables using PS in TSQL

Best bet would be to use PS separately