Scripts for DB

  • Hello, somebody have a script for create a database with all (or partial) data, because the script that Enterprise Manager generate is only for database structure.

    I will be thankful if they can give to me, because it's urgent.

    Thank you.

    Deusdit Correa Cornejo

    ----------------------

    Br. Computer Science

    Microsoft Certified Database Administrator

    Analyst Programmer

    ----------------------


    Deusdit Correa Cornejo
    ----------------------
    Br. Computer Science
    Microsoft Certified Database Administrator
    Analyst Programmer
    ----------------------

  • Sorry by the duplicate :).

    Deusdit Correa Cornejo

    ----------------------

    Br. Computer Science

    Microsoft Certified Database Administrator

    Analyst Programmer

    ----------------------


    Deusdit Correa Cornejo
    ----------------------
    Br. Computer Science
    Microsoft Certified Database Administrator
    Analyst Programmer
    ----------------------

  • No built in way that I know of, usually you BCP the data out and then have a script that loads it back in. Red-Gate sells a tool that will generate a series of insert statements for you, actually compares the data between two tables and generates the diff.

    Andy

  • Thanks Andy, i download the trial version this tool, SQL Compare and for me is a very good tool.

    Thanks again.

    Deusdit Correa Cornejo

    ----------------------

    Br. Computer Science

    Microsoft Certified Database Administrator

    Analyst Programmer

    ----------------------


    Deusdit Correa Cornejo
    ----------------------
    Br. Computer Science
    Microsoft Certified Database Administrator
    Analyst Programmer
    ----------------------

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

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