Comments
Sort by recent activity
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
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?
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...
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
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...