ApexSqlDiff similar aplication

  • I start doing this...and is working,but there is stuff I still need to do

    I have another question:D

    Is there an equivalent to '\ n'

    When I build the create string I want to use something like this.

    Any suggestion?

    thx

  • I want an advice

    When I compare two tables or two sp's should I create a local database and put the result there?

    The number of comparison is quite big and I think that this has to be stored...

    thx

  • shnex (11/18/2008)


    I want an advice

    When I compare two tables or two sp's should I create a local database and put the result there?

    The number of comparison is quite big and I think that this has to be stored...

    thx

    It depends. Are you going to want to go back and look at previous comparisons? If not, then why store it? If, yes I think you need to evaluate if a database is the place to store this, would XML or text files be better since there will be a lot of text to be saved?

  • I want to compare...tables,sp, views, etc

    After that I want to go back and take the name and the create string I build and use it

    So , yes, I will need this information after that

    I don't know how to do this ,because creating and droping some tables might take some time and resources ,but for creating the "create" string I want to use some sp(execution plan...) rather than queries.

    I want to do this first on the same server between 2 databases.If I succeed I will try on separate servers.

    I think the xml solution is the best...but I don't have a clear image...if you could give me some hints....

    thank you

Viewing 4 posts - 16 through 18 (of 18 total)

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