Powershell: Copy MSSQL table between different DB instances
Sometimes I need to copy data from production database to my local SQLEXPRESS instance and usually I use „SQL Server Import And Export Wizard”. It is probably easiest and fastest way to set things up and copy required tables to your local environment but I often need to repeat same process to get latest data to make analyse and I decided to make it even easier and… faster.