Home Forums SQL Server 2005 Administering Creating an index RE: Creating an index

  • September 2, 2009 at 5:53 am

    #1048043

    Clive Strong (9/1/2009)

    Very true...If only my company would let me get my hands on EE!!

    As for moving data from certain tables from production to development, you can use SSIS/DTS, BCP, backup and restore (if you placed files in specific file groups) or direct copy (even a subset of data would help).

    Thanks so much for the advice. I will attempt to learn how to use the options you suggested (SSIS/DTS, BCP). Can any of these be used on the live database?

    Thanks