Home Forums SQL Server 2005 Development Copy DB Tables from PRod to DEV RE: Copy DB Tables from PRod to DEV

  • November 13, 2012 at 3:04 am

    #1558414

    poratips (11/12/2012)

    Hello,

    I have situation that my developer wants some tables from Prodction DB server to their desktop m/c.

    We have already sql express installed and Database and tables ae already there but no data.

    In this Database, we need some of the tables with for specific date and dept.

    What will be the best way to handle this?

    My problem is that i can't use Task - Copy wizard from prod server as i need some tables I need to copy data full and some of the tables i need to restrict by Date but this Date will last thre months and

    I have Date column in all those tables which i need jsut last three months data.

    Appreciate your help!

    Thanks,

    I would create a custom SSIS package which loads the tables in full that you need and then runs the queries you need to export only the sub set of the data.