Can I use sql bulk copy to copy data within the same server ?
Yes. In fact, in the demo code shown here, they copy to a table within the same database.