Home Forums SQL Server 2005 Development How to copy production DB into New Developmant Database? RE: How to copy production DB into New Developmant Database?

  • November 7, 2012 at 11:38 am

    #1556884

    poratips (11/6/2012)

    Thanks So much.

    I have another 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.

    Thanks,

    If the developers need subsets of records from specific tables, then BCP out to files in native format, and the developers can then BCP the files into tables on their local instance. Insure that the column sequence and datatypes in development are exactly the same as what's in production, and you won't have to screw with format files, making this a breeze.

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