How do I copy table structure and data from one database server to another?

I have a dba in a dev environment and the same dba exists on the prod server. I need to copy an existing table from dev to prod. How do I do that?

Dev server:
Catalog Name: Budget
Table Name: BU_2010

Prod Server
Catalog name: Budget
Table name from dev needs to be copied to prod

Who is Participating?
Aneesh RetnakaranDatabase AdministratorCommented:
try this sp to generate the insert script
Aneesh RetnakaranDatabase AdministratorCommented:
right click the database in management studio, go to tasks, then export data.  from there, there is a wizard that guides you.  integrations services is what powers it from behind.
All Courses

From novice to tech pro — start learning today.