Skip to Content

Copy a table from one database to another -SQL

Nov 07, 2016 at 06:44 AM


avatar image
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.


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

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.



10 |10000 characters needed characters left characters exceeded