Comments
Sort by recent activity
You're welcome [image] / comments
You're welcome
I've seen this behaviour in the data compare product sometimes. What happens is that you can insert binary data into a string field in a database but no check is performed on the binary data to make sure that it is valid unicode. So what happens is we read the information from the database and store it in a temporary file and when we go to read that temporary file it tried to interpret the unicode and fails.
It's a known 'feature' of the classes we use for temporary file storage in .NET 1.1. There is no workaround currently but to find the offending string and fix it or remove it from the project.
Hope this explains what is going on at least. / comments
I've seen this behaviour in the data compare product sometimes. What happens is that you can insert binary data into a string field in a database but no check is performed on the binary data to mak...
OK it has taken me a little bit of time to work out why I have done this in this manner but I think I've finally got to the bottom of it. The with nocheck should only happen for foreign keys of tables which aren't being migrated. So take the scenario...
Table1 data(1,2,3)
Table2 data(1,2,3) foreign key to Table1
Table3 data(1,2,3) foreign key to Table2
We have this data in two databases. In one database we delete all the 3s. We then choose to synchronise the databases but we choose not to sychronise Table2. If I was to drop and re-create the foreign keys all without WITH NOCHECK then it would fail as the data looks like...
Table1 data(1,2)
Table2 data(1,2,3) foreign key to Table1
Table3 data(1,2) foreign key to Table2
So I must drop the foreign key for table2 and recreate it with nocheck or the migration would fail.
Hope this makes sense. [image]
PS I have the comment in my code... // Currently this will break the sql compare NOCHECK behaviour [image] / comments
OK it has taken me a little bit of time to work out why I have done this in this manner but I think I've finally got to the bottom of it. The with nocheck should only happen for foreign keys of tab...
OK we've had a bit of an investigation to work out what is going on here. For SQL Data Compare in your licenses.licx file you need to have the lines RedGate.SQLCompare.Engine.Database, RedGate.SQLCompare.Engine
RedGate.SQLDataCompare.Engine.ComparisonSession, RedGate.SQLDataCompare.Engine
Then the application should work (with warning screens on the clients machine). They do not have to have the evaluation version of the software installed.
Hope this helps. / comments
OK we've had a bit of an investigation to work out what is going on here. For SQL Data Compare in your licenses.licx file you need to have the linesRedGate.SQLCompare.Engine.Database, RedGate.SQLCo...
We don't support migrating any system tables including dbo.sysdiagrams. We have no plans to support this in the future unless it is something that we get many requests for.
Hope this clears it up at least. / comments
We don't support migrating any system tables including dbo.sysdiagrams. We have no plans to support this in the future unless it is something that we get many requests for.
Hope this clears it up a...
Right, I believe I've replicated the issue and fixed it.
If you can try the latest bugfix release and see if that helps. ftp://support.red-gate.com/patches/Sche ... 5fd341.zip / comments
Right, I believe I've replicated the issue and fixed it.
If you can try the latest bugfix release and see if that helps.ftp://support.red-gate.com/patches/Sche ... 5fd341.zip
Having a look through the code I think you are correct. We attempt to parse the privilege information into an enum but when it encounters something it doesn't recognise it default to "none" which returns the blank string you are seeing.
I'll take a look into it and see if I can get you a branch that helps. We've not done much work on 12c but aim to be responsive to issues that people hit so this is very useful for us (and everybody who uses 12c in the future). / comments
Having a look through the code I think you are correct. We attempt to parse the privilege information into an enum but when it encounters something it doesn't recognise it default to "none" which r...
Excellent, glad I've fixed it already. It was something a customer reported via the error reporting in the product. Often these reports give me enough information to reproduce and fix the issue.
Just let us know if you encounter any other issues. / comments
Excellent, glad I've fixed it already. It was something a customer reported via the error reporting in the product. Often these reports give me enough information to reproduce and fix the issue.
Ju...
Dan F wrote:
richardjm wrote:
http://blogs.red-gate.com/blogs/richard ... 8/258.aspx
Hiya Richard. The utility sounds great, but when using it on snapshots created with V5, I get
Unexpected Exception:
The database snapshot was saved by a newer version of SQL Compare
Any chance of a recompile for V5 snapshots? I'd love to use this in our Vault server for sure!
Just to let you know in case you've not found out already. I've done a recompile that lets Scream work with v5.05/5.1/5.2 releases. You can get instructions on how to get it from here...[/url]
Hope this helps. / comments
Dan F wrote:
richardjm wrote:
http://blogs.red-gate.com/blogs/richard ... 8/258.aspx
Hiya Richard. The utility sounds great, but when using it on snapshots created with V5, I get
Unexpecte...
petteroe wrote:
Thanks Richard,
I have been playing soldier in the national guard this week, so I haven't gotten around to testing your app yet.
Can I use the snapshot of the database to revert back to an earlier scheme without loosing data (except for the obvious situations where this operation will remove columns etc)
Morten
Yes you can - using SQL Compare. Just use the snapshot as the source and your database as the destination. The utility I mentioned is just a way to get a quick view on what has changed and won't produce any SQL. / comments
petteroe wrote:
Thanks Richard,
I have been playing soldier in the national guard this week, so I haven't gotten around to testing your app yet.
Can I use the snapshot of the database to revert ...