Comments
Sort by recent activity
Hello,
For anyone looking at this post, the discussion is continued here: http://www.red-gate.com/MessageBoard/vi ... hp?t=21865
Thanks,
Evan / comments
Hello,
For anyone looking at this post, the discussion is continued here: http://www.red-gate.com/MessageBoard/vi ... hp?t=21865
Thanks,
Evan
Hello,
There's no way that I know of to turn off the server assignment, but I just looked into this more and it will only try to reseed if you have the "delete data from table before generation" option checked. As long as you're not deleting data, if the next server assigned value is 20000, SQL Data Generator will just go from there.
Hope that helps.
Thanks,
Evan / comments
Hello,
There's no way that I know of to turn off the server assignment, but I just looked into this more and it will only try to reseed if you have the "delete data from table before generation" op...
Hello,
Thanks for your post.
I can't think of a very useful way to deploy only a subset of the data in your tables while also keeping the foreign key constraints intact.
SQL Data Generator might be a better tool for your use case. You can generate test data and also have cross-column and cross-table dependencies. It should automatically recognize your foreign keys as well.
You can also use your original table as a data source and just pick some proportion of the rows. (See this documentation article: http://documentation.red-gate.com/displ ... s+or+views)
Hope that helps.
Thanks,
Evan / comments
Hello,
Thanks for your post.
I can't think of a very useful way to deploy only a subset of the data in your tables while also keeping the foreign key constraints intact.
SQL Data Generator might be...
Hello,
I just did a quick test to see how it handled an identity column starting at 1000, and it appears to work as expected.
Thanks,
Evan / comments
Hello,
I just did a quick test to see how it handled an identity column starting at 1000, and it appears to work as expected.
Thanks,
Evan
Hello,
Thanks for your post.
This should work with SQL Compare (one thing to note is that there's a bug in 10.7 that causes retrieval of migration scripts to fail).
You'll need to use the following switches: /sourcecontrol1
/revision1:<revision # or "head">
/server2:<target server>
/database2:<target database>
/sfx:<xml file with source control location>
/mfx:<xml file with migration folder location>
/ScriptFile:<path to .sql script you want to generate>
To create the xml files for sfx and mfx, you'll need to look at the extended properties of your linked database. The sfx xml file should be the value of "SQLSourceControl Scripts Location" and the mfx xml file should be the value of "SQLSourceControl Migration Scripts Location".
Here's the documentation on our switches: http://documentation.red-gate.com/displ ... mmand+line (note: it says the sfx and mfx switches are deprecated, but as far as I know they're the only way to get this to work).
Hope that helps.
Thanks,
Evan / comments
Hello,
Thanks for your post.
This should work with SQL Compare (one thing to note is that there's a bug in 10.7 that causes retrieval of migration scripts to fail).
You'll need to use the following...
Hi Brandon,
Thanks for your post.
Unfortunately if you have your purge settings set for 1 month, that means there will never be more than a month of data in your repository, so you won't have access to any old data. An added obstacle is that the SQL Monitor data repository is undocumented and pretty tough to work with to be honest.
In theory, you could keep the purge settings really high (and leave a year's worth of data), then go to the analysis page and select a 28 day time period and compare to previous months.
One other thing you could do would be to use the export to csv function on the analysis page and save it off every month, but you'd have to use a different tool to display the analysis you're looking for.
Sorry about the inconvenience.
Thanks,
Evan / comments
Hi Brandon,
Thanks for your post.
Unfortunately if you have your purge settings set for 1 month, that means there will never be more than a month of data in your repository, so you won't have acces...
For anyone else looking at this post, restarting the Base Monitor service seems to have solved it. It looked like it was related to a WMI outofmemory error. / comments
For anyone else looking at this post, restarting the Base Monitor service seems to have solved it. It looked like it was related to a WMI outofmemory error.
Hello,
Thanks for your post and sorry you're experiencing issues with SQL Monitor.
One hypothesis I have is that the account the "SQL Monitor 4 Base Monitor" service is using has changed. (There shouldn't be anything different about the data collection methods between the two versions.)
You can also check on the monitored servers page (in configuration) to see what the failures are. If you hover over the entity that isn't connected, there should be a "show log" link on the right. That should tell you which data collection methods are failing and what the error messages are.
If you'd like to troubleshoot further, we have a ticket open for you (#23640), so feel free to respond to the email you should've gotten from our support system or email support@red-gate.com.
Thanks,
Evan / comments
Hello,
Thanks for your post and sorry you're experiencing issues with SQL Monitor.
One hypothesis I have is that the account the "SQL Monitor 4 Base Monitor" service is using has changed. (There s...
Hello,
Thanks for your post.
You should be able to modify the comparison options to ignore whitespace and ignore comments -- this should stop your stored procedures from showing as differences.
Please let me know if you have further questions.
Regards,
Evan / comments
Hello,
Thanks for your post.
You should be able to modify the comparison options to ignore whitespace and ignore comments -- this should stop your stored procedures from showing as differences.
Ple...
There should be a "filter.scpf" stored in your source control repository. In dedicated model, you should be able to modify that directly, then unlink/relink to source control and get latest. In shared model, it might be a bit trickier -- I think you'll have to do a manual modification in both the repository and the local differencefilter.xml. / comments
There should be a "filter.scpf" stored in your source control repository. In dedicated model, you should be able to modify that directly, then unlink/relink to source control and get latest. In s...