Post reply

Segregating data and schema script

  • August 11, 2004 at 7:58 am

    #108778

    I need to know how does one go about taking the data backup(exclusively)...Can we generate some script(Insert in tables)? Any tool to achieve the same ?
     
    The backup does give u the whole stuff(data + schema).But the following is what we plan  to achieve....
    a) take the schema script and create the database.
    b) take the data backup(how u do that ...have to find) and restore it in ur new database.
     
    Let me share with u a typical scenario :::
     
    a team member has created lots of data with the prev version of the database.But since schema has changed he has to go about recreating the database at the same time restoring the already created massive records he had in the previous database (or may run a script which has all the inserts 4 all tables --This is what i am looking for !)
     
     
    Regards
    Poonam

  • August 11, 2004 at 11:46 am

    #518552

    I'm not sure I understand your question, but if you want to copy tables schema and data from one database to another database, you can use DTS.

    Greg

    Greg

  • August 12, 2004 at 2:09 am

    #518604

    check out http://www.dbghost.com which gives out a free schema and data scripting tool as part of the evaluation of the product.

  • August 12, 2004 at 9:33 am

    #518708

    Poonam,

    Step 1:

    Right Click your database in SQL Server Enter. Manager and select the option "All Tasks". You will find here different options that can help you. Specifically, "Import/Export Data" and "Back Up Data"

    Step 2:

    In your EM, expand the Server that you are working with. Expand the "Managemnet" node and select Backup. Right click the "BackUP" option and create a new back up. You can set it to recurrances as per your choice. You don't need to right scripts for reoccurances.

    Hope I replied your answers.

    Thanks and Take Care.

    Nilesh

     

     

  • January 31, 2006 at 1:00 pm

    #618001

    Try http://www.sqlscripter.com for data scripting.

    - Thomas

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

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