Skip to Content
0

Copy a table from one database to another -SQL

Nov 07, 2016 at 06:44 AM

42

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Denise Meyer
Nov 07, 2016 at 07:00 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded