Activity overview
Latest activity by RogerHart
Hi Grant
You're quite right, the documentation didn't get updated properly when we made some command line changes. We'll get the docs updated shortly.
It is indeed the case that options can be set with either a GUI project or /Options, and not both.
This was changed as some users were finding the previous situation confusing, and the order of precedence for options was not clear if both ways of specifying theme were allowed.
The main reason to use a project from the command line is the ease of configuring filters. Some of our users also find it more intuitive to use the GUI for setting up their projects. / comments
Hi Grant
You're quite right, the documentation didn't get updated properly when we made some command line changes. We'll get the docs updated shortly.
It is indeed the case that options can be set ...
Hi
You can get a bit more information on the SQL Data Generator command line interface by using the command:
sqldatagenerator /? /v /html >> c:\filename.html
To use a project in a specific location, you would use a command like:
sqldatagenerator /project:c:\Test\ProjectName.sqlgen / comments
Hi
You can get a bit more information on the SQL Data Generator command line interface by using the command:
sqldatagenerator /? /v /html >> c:\filename.html
To use a project in a specific location...
Hi
Your syntax there looks fine to me - what is the error message you get when this fails? / comments
Hi
Your syntax there looks fine to me - what is the error message you get when this fails?
A newly created scripts folder doesn't contain data scripts. To update the target scripts folder with data from the source, perform the comparison, select the rows you want to include, and then synchronize.
Data scripts are not currently created from the Project Configuration dialog box as, for many databases, this would take a long time, and be insufficiently specific. Not least because we can't really know in advance which tables contain static data.
Instead, comparing and synchronizing an "empty" scripts folder allows for finer grained control over what data is stored in the scripts folder. You can filter the comparison using the Tables & Views tab, and by applying a WHERE clause, and then use the Results and Row Differences panes to select data at a row level.
Of course, it's possible we could be doing a better job of articulating that. / comments
A newly created scripts folder doesn't contain data scripts. To update the target scripts folder with data from the source, perform the comparison, select the rows you want to include, and then syn...
Thanks for spotting that. We're doing a bit of work on SQL Compare soon, so I'll make sure it gets added to the documentation. / comments
Thanks for spotting that. We're doing a bit of work on SQL Compare soon, so I'll make sure it gets added to the documentation.
You can also find some information and examples on using the SQL Compare command line starting here: http://www.red-gate.com/supportcenter/Content.aspx?p=SQL%20Compare&c=SQL_Compare/help/8.0/SC_CL_Getting_Started.htm&toc=SQL_Compare/help/8.0/toc547547.htm / comments
You can also find some information and examples on using the SQL Compare command line starting here:http://www.red-gate.com/supportcenter/Content.aspx?p=SQL%20Compare&c=SQL_Compare/help/8.0/SC_CL_G...
You can also find more detailed information about using the command line, including some worked examples, in the online help for SQL Compare: http://www.red-gate.com/supportcenter/C ... 547547.htm / comments
You can also find more detailed information about using the command line, including some worked examples, in the online help for SQL Compare:http://www.red-gate.com/supportcenter/C ... 547547.htm
What's different in SQL Compare 8 Beta
A lot of people are wondering what's changed between SQL Compare 8 and the previous version.
You can find out more about the differences in this article:http://www.red-gate.com/supportcenter/C ... ...
Updated help for the command line interface was released alongside SQL Compare 7.0. This includes the content from the /verbose help, as well as worked examples and details of the options and command line syntax.
The updated help for the SQL Compare 7.0 command line begins here: http://www.red-gate.com/supportcenter/Content.aspx?p=SQL%20Compare&c=SQL_Compare/help/7.0/4250.htm&toc=SQL_Compare/help/7.0/toc356444.htm / comments
Updated help for the command line interface was released alongside SQL Compare 7.0. This includes the content from the /verbose help, as well as worked examples and details of the options and comma...