Copy a table from one database to another -SQL

[Former Member]

Hi All,

I would like to know the method of copying a table structure and its contents from one data base,say DB1 to another database DB2 using Stored Procedure in SQL.

TIA

[denise_meyer]

So are you using Data Services at all? With Data Services you can connect to the table object as source and then just copy it to a "temp" table object which will create the same structure in the dataflow. If you want to call a stored procedure from data services you can do that as well, import it in the datastore as a function and then use it in the dataflow (in sql transform, script, query). If you are asking how to write such a store procedure, then probably post to this question to a database question website to get help with syntax for your particular database.

Thanks,

Denise