Comments
Sort by recent activity
If you're referring to comparing versions of databases within source control, this has to be done via SSMS, you cannot do it from the commandline unfortuantely. / comments
If you're referring to comparing versions of databases within source control, this has to be done via SSMS, you cannot do it from the commandline unfortuantely.
The latest version of SQL Compare with the SQL Server Integration Pack should help with these kind of things. You can now initiate a SQL Compare session directly from within Management Studio, and target it against source-controlled databases - there's a screenshot here: clicky / comments
The latest version of SQL Compare with the SQL Server Integration Pack should help with these kind of things. You can now initiate a SQL Compare session directly from within Management Studio, and ...
Currently, you won't get the blue blobs for static data changes. You'll need to visit the commit tab, where it should show up.
We do have a job logged to implement this (ref. SOC-2047) although I'm not currently sure when it is likely to be implemented. If it's an important feature for you, you can suggest it on our uservoice forum here so other users can also vote for it. / comments
Currently, you won't get the blue blobs for static data changes. You'll need to visit the commit tab, where it should show up.
We do have a job logged to implement this (ref. SOC-2047) although I'm...
Hi there.
The usual way to acheive this is to utilise the commandline (see http://bit.ly/eQBZjz), place your command into a batch file, and then use Windows Task Scheduler to run that whenever you want.
We don't have any built-in scheduling I'm afraid. / comments
Hi there.
The usual way to acheive this is to utilise the commandline (see http://bit.ly/eQBZjz), place your command into a batch file, and then use Windows Task Scheduler to run that whenever you ...
Filtering out users and groups is a good start. You may also need to go to the Options tab of your project, and tick the option to Ignore "Permissions" and "Users' Permissions and Role memberships".
The other potential cause is if dependent objects are perhaps triggering the permissions to be included, but try with the above options set and see if it helps. / comments
Filtering out users and groups is a good start. You may also need to go to the Options tab of your project, and tick the option to Ignore "Permissions" and "Users' Permissions and Role memberships"...
Thanks for your post.
I don't think Data Generator performs validation to account for DST which is why you have encountered this issue.
I've logged it as a bug (ref SDG-923) although the problem is a bit more complex than it would initially appear. I don't think all regions necessarily switch daylight savings at the same point (so the US will perhaps do it a couple of weeks after/before the UK for instance). This means the invalid date you have could well be valid in another country!
So, it may be possible to fix it, but we'd also need to investigate region checking, and would it be the region of your PC, or the SQL Server you're working against (they could be different...)
In any case, I've logged it, as I mentioned above, and we'll let you know if a fix becomes available. / comments
Thanks for your post.
I don't think Data Generator performs validation to account for DST which is why you have encountered this issue.
I've logged it as a bug (ref SDG-923) although the problem is...
Thanks for your post, I've mailed you directly to run through a few things to see if we can work out what's going on. / comments
Thanks for your post, I've mailed you directly to run through a few things to see if we can work out what's going on.
You should be able to get around this by enclosing the DB name with spaces in double quotes:
sqlcompare /db1:Adventureworks /db2:"Some Spaces"
The issue occurs because spaces separate the switches so without the quotes the database name is interpreted as just the part up to the first space and you get the error. / comments
You should be able to get around this by enclosing the DB name with spaces in double quotes:
sqlcompare /db1:Adventureworks /db2:"Some Spaces"
The issue occurs because spaces separate the switches ...
There are a couple of things you can do to help - firstly, once you get to the Comparison Results, you can click "Filter setup", and un-tick "Users" in the list.
The other thing that may achieve what you want is to edit your Project Options, and tick to ignore things such as Permissions, User Permissions & Role Membership, and any other items you require. / comments
There are a couple of things you can do to help - firstly, once you get to the Comparison Results, you can click "Filter setup", and un-tick "Users" in the list.
The other thing that may achieve wh...
The following link should help you out - it details copying data from an existing DB, and then using generators on just certain columns: http://www.red-gate.com/supportcenter/C ... g_Data.htm / comments
The following link should help you out - it details copying data from an existing DB, and then using generators on just certain columns:http://www.red-gate.com/supportcenter/C ... g_Data.htm