Post reply

Getting table structure and data to outside consultant

  • June 25, 2007 at 10:10 am

    #196577

    The company I work for has hired an outside company to do some development and we have to give them a group of tables along with a sample of data that will be used in the program.

    What is the best way to do this. There will be about 5-10 tables from one database and 5 tables from another database. Plus new tables that have not yet been created.

    I was thinking about scripting the tables and sending a file populated with a sample of the data.

    Any help would be greatly appreciated

     

    Thanks

  • June 25, 2007 at 11:36 am

    #714982

    Create a blank database with same name and do SELECT INTO statement of the 5-10 tables and the 5.  Then create the new tables as needed.

     

    Kind regards,
    Gift Peddie

  • June 25, 2007 at 11:51 am

    #714988

    Then should I back up the db and send of the files.

     

    Thanks

  • June 25, 2007 at 12:05 pm

    #714991

    That is a very good question for 2005 make sure your backup use the C dirve if not the person need to create backup devices and restore in recovery mode and then restore again to get the database.  I had to create four sets of code to restore a database created on E drive and SQL Server will not let me use the GUI.  Hope this helps

     

    Kind regards,
    Gift Peddie

  • June 26, 2007 at 4:39 am

    #715166

    There is no need to backup the database.

    You can follow the earlier suggestion. You can give sample data to the customer instead of giving the real data.

    Minaz Amin

    "More Green More Oxygen !! Plant a tree today"

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply