What are the challenges you face when working across database platforms? Take the survey
Options

do not include plumbing for transactions

sandusandu Posts: 20
edited August 30, 2005 1:30PM in SQL Compare Previous Versions
Hello,
If I understand this option will cause the synchronization not to be in one transaction. what would be the similar attribute if I do the comparison with an XML file?
Sandu

Comments

  • Options
    Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    Hello Sandu,

    To set this option for the command line version, you would set it in the options in the XML command file like this:
    <?xml version="1.0"?>
    <commandline>
        <database1>DataChooseRec1</database1>
        <database2>DataChooseRec2</database2>
        <options>IgnorePermissions,IgnoreComments</options>
        <scriptfile>c:\temp\sync.txt</scriptfile>
    </commandline>
    
    You may want to be mindful that once you start specifying options, the default options are overridden so you will need to specify all of the options that you want to use in the compare explicitly.
  • Options
    hello Brian
    10x
    Sandu
This discussion has been closed.