I'm trying to find information on how to import selected data from one SQL database to another using C# (or any language for that matter) or the cmd line. aka: I dont want to use the wizard.
I could export to a CSV file, then import... but that seems needslessly complicated and (run) time consuming. Any suggestions?