Activity overview
Latest activity by keithr
Thanks for the update.
I think I am able to work around the issue. I am using the query below to modify the type. Converting the ServeMajorVersion to SqlServerVersion seems to get me the compatibility level number I need without alot of parsing. String.Format("ALTER DATABASE {0} SET COMPATIBILITY_LEVEL = {1}0;", DatabaseName, CType(oDB.ServerMajorVersion, SqlServerVersion))
/ comments
Thanks for the update.
I think I am able to work around the issue. I am using the query below to modify the type. Converting the ServeMajorVersion to SqlServerVersion seems to get me the compatibil...
Changing Compatibility Level
Is there a way use the version settings of the SDK Database object to update the compatibility level of a database before comparing?
We have several clients that use our software and migrate from v...
Until you had asked, no I hadn't compared a backup to a live db. But that was enough to get me to try it out just to see...
The backup has columns missing from certain tables. It looks like the columns that are missing are all nvarchar(x). I noticed because as soon as I opened the project the column count was 17 of 18 col. without any edititing. If I compare the database to itself, the columns are fine.
Also, when starting a new backup compare project, I didn't get the warning about custom compares not working. But after change datasources to the databases I was able to get the warning message, though I haven't been able to replicate what sequence of steps lets me get the custom compare warning.
But this is still way cool. The pivot view is great makes it much more readable. And the SQL on the tab is very handy.
Keep up the good work.. I'll be keeping my fingers crossed that Bundle Pro 6 is done before my support runs out / comments
Until you had asked, no I hadn't compared a backup to a live db. But that was enough to get me to try it out just to see...
The backup has columns missing from certain tables. It looks like the col...
Just In Time..
This worked out well for me. I have to track differences and move them into the new database while avoiding overwriting new data with old data or getting PK | FK combos mixed up.
Everything has bee...
Sorry, for the delay in responding. I checked all the previous build outputs and none had binary turned on. Turning it on doesn't help either. (had to try). I was able to get up around 720 views into a chm file, but it still crashes. I do believe its something to do with the views design, but don't know what that is yet. / comments
Sorry, for the delay in responding. I checked all the previous build outputs and none had binary turned on. Turning it on doesn't help either. (had to try). I was able to get up around 720 views in...