<div>
try this sp to generate the insert script 
</div>


try this sp to generate the insert script

<div>
<a href="http://vyaskn.tripod.com/code/generate_inserts.txt" rel="ugc">http://vyaskn.tripod.com/code/generate_inserts.txt</a>
</div>


http://vyaskn.tripod.com/code/generate_inserts.txt [http://vyaskn.tripod.com/code/generate_inserts.txt]

<div>
right click the database in management studio, go to tasks, then export data. &nbsp;from there, there is a wizard that guides you. &nbsp;integrations services is what powers it from behind.
</div>


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.

<div>
<div class="content wysiwyg-content">
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?<br />
<br />
Dev server:<br />
Catalog Name: Budget<br />
Table Name: BU_2010<br />
<br />
Prod Server<br />
Catalog name: Budget<br />
Table name from dev needs to be copied to prod<br />
<br />
Thanks!<br />

</div>
</div>


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

Thanks!


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

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.