title: Dump data from one database table to the other database
body: <p>I have to write a code in vb.net (2010).
  To get a data from Database A table 1 and dump it to Database B Table 2.
  What’s the best way to do this? Most efficient way? I know I can do this very easily in sql management studio but I need to write a code to do this in vb.net.
  Thanks!</p>