Home Forums SQL Server 2014 Development - SQL Server 2014 Stored Procedure to transfer all DB objects including data from one schema to another schema RE: Stored Procedure to transfer all DB objects including data from one schema to another schema

  • GA_SQL (12/7/2016)


    My objective is to move the contents of one db to another db

    You can easily use the SSMS Import and Export Wizard for this, and then if it needs to be repeated, choose the option to save process as a SSIS package which you can run on demand.

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho