Skip to Content
avatar image
Former Member

Copy a table from one database to another -SQL

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • 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.


    Thanks,

    Denise

    Add comment
    10|10000 characters needed characters exceeded