Search
-
Re: Database Logins being removed
Discussion by Brian Donahue · · Home› Discontinued and Previous Versions› SQL Toolkit Previous VersionsHi Chris, Actually, I can't see this happening in a Toolkit application. I've done a migration with Options.IncludeDependencies and Options.IgnorePermissions set, and I don't get an sp_addlogin in my script. Can you give that a try and see if you get the same results? Thanks, Brian Donahue Red Gate Technical Support "Chris… -
Database Logins being removed
Discussion by Brian Donahue · · Home› Discontinued and Previous Versions› SQL Compare Previous VersionsHi Chris, Actually, I can't see this happening in a Toolkit application. I've done a migration with Options.IncludeDependencies and Options.IgnorePermissions set, and I don't get an sp_addlogin in my script. Can you give that a try and see if you get the same results? Thanks, Brian Donahue Red Gate Technical Support "Chris… -
Existing custom snippet causes "Failed to import snippets - JSON value could not be converted"
I've read several reports of this error as I've been seeing it also. In my investigation I noticed that my ADS custom snippets are the problem while the error suggests that the issue is happening while processing my SSMS snippets. The problem is, I don't have any SSMS snippets, that file is untouched from installation. I… -
initial value reset when modifying tables with identity columns?
if you have a table with an identity column, and have data in it, then later need to modify that table, the script created to deploy the table, creates a new one, inserts the correct records, with the correct id's, but because it is a new table, with a "new" identity column, the system sequence behind the column is still… -
Materialized View and timestamps /DMS-34049
SCO include state info of the instance of MV into its metadata in the form of the current refresh time (in relation to log files). That is very inconvenient For MV present and identical on source and dest DB SCO will generate a deployment script as -- -- Script generated by Schema Compare for Oracle 4.0.11.536 on… -
Percentage is inaccurate while registering/comparing db?
Discussion by steveschoon · · Home› Discontinued and Previous Versions› SQL Toolkit Previous VersionsI'm comparing a small snapshot (4-6 tables) to a larger database (40-50 tables) using a C# app and the toolkit. It is working fine, except for the fact that the percent complete appears to be inaccurate. Writing everything to the debug window in VS.NET during the compare generates this output: Percentage: 0 Message:… -
Suggestions..
Discussion by Brian Donahue · · Home› Discontinued and Previous Versions› SQL Compare Previous VersionsHi Gary, My name is Brian Donahue, and I support Red Gate Software. Thanks for your enquiries: > Allow the Database passwords to be remembered when connecting to a database. Then they would have to be stored somewhere, like in the registry. I don't think most people would be comfortable with that. Using integrated security… -
Re: All values for Message.MessageTypeID
Hi Catalin, Below is an extract of the warning IDs and the messages we display within SQL Compare, I hope it helps. We can not guarantee that these IDs will not change in the future as we improve the product. Regards, David TargetUnsupportedSynonym The synonym {0} is not supported in the target database version.… -
Re: Columns in search results
Hi, I've run into a bit of difficulty getting this to work because of the custom fields. The way that the bugs.asp page works, it will only include the custom fields if you check the 'summary of issue details', which kind of defeats putting them in the rows of the bug report. So we'll have to figure out a way to get… -
Re: Break, Cancel BlockExecutor
Comment by Brian Donahue · · Home› Discontinued and Previous Versions› SQL Comparison SDK Previous VersionsHello, I'm not sure how you detect the locking automatically - the SDK doesn't do that. I always thought the SET TRANSACTION ISOLATION LEVEL SERIALIZABLE was specified by SQL Compare to prevent that sort of thing. If you want to cancel a synchronization, you can use CancelOperation but I assume this would only work in a…
946 results