Import export wizard at the commandline


Well, it seems like even if you’ve worked with SQL SERVER for a while, you’re always lightly to learn something new.

Today I discovered that in order to use the “Import / Export Wizard” we don’t even have to open management studio.

Just type “dtswizard” into the run box or at the command prompt – regardless of if it is a Powershell prompt or a DOS prompt (its in the Path!)

Pretty cool – although obviously you’ll have to populate the entire wizard yourself.












Well, that’s all from me folks.

Have a great day.



Tags: , ,

About Martin Catherall

Martin Catherall is Senior SQL consultant at SQL Down Under, based in Melbourne, Australia. Martin is also a Microsoft Data Platform MVP and Regional Mentor (RM) for the Professional Association for SQL Server. Prior to relocating to Australia he was extremely active in the Christchurch, New Zealand data community - founding the local SQL Server user group and organizing SQL Saturday Christchurch - which later became SQL Saturday South Island. He likes learning interesting stuff about processing and storing data and passing on his knowledge. In his spare time he likes to learn guitar and hang out with his two young sons Callum Glen and Robert Michael.