Activity overview
Latest activity by davebublitz
Restore to a Smaller Drive
If I have a 2 TB database with 500 GB of data can I restore the database to a server with only 1 TB of free disk space? Last time I tried this it failed because there was not 2 TB of free space to...
David,
Here is what was in one of the date columns:
-29762-12-16 499:03:07.627
I would say it is "special"! This happened on a development server so we don't know how this data was created.
Dave / comments
David,
Here is what was in one of the date columns:
-29762-12-16 499:03:07.627
I would say it is "special"! This happened on a development server so we don't know how this data was created.
Dave
We experienced this exact error today and we have the .NET Framework 2.0 installed on the workstation. We still have a copy of 4.0 and it reported an invalid date problem. We found that somehow we did get an invalid date in row. After removing the one row SQL Data Compare 5 was able to compare and update the tables.
Perhaps this is the real issue?
Dave / comments
We experienced this exact error today and we have the .NET Framework 2.0 installed on the workstation. We still have a copy of 4.0 and it reported an invalid date problem. We found that somehow w...
Hi Brian,
Yes, I should have posted under Data Compare. Thanks for logging this as an improvement for a later version...5.30 I hope!
Thanks,
Dave / comments
Hi Brian,
Yes, I should have posted under Data Compare. Thanks for logging this as an improvement for a later version...5.30 I hope!
Thanks,
Dave
Owner not displayed with object name
When configuring a comparison project the owner of the object is not displayed in the Tables & Views screen. In our case, several tables have the same name but have different owners, dbo or audit....
Hi Brian,
I found the problem in the SQL Data Compare product but did duplicate the issue in the SQL Compare product. I can check the "Treat items as case sensitive" box under Behavior in the Options tab using SQL Compare and the compare will complete successfully so I guess there is no problem in SQL Compare. However, I don't see an "Ignore User Property" option in the SQL Data Compare product and this is the product we use the most.
Yes, it appears to not be checking the case sensitivity for user names and it needs to check case. Perhaps Ignore case needs to be added to the Comparison Behavior section under the Options Tab when a Project is configured in SQL Data Compare? Does this mean you will open a job to fix the issue?
Thanks,
Dave / comments
Hi Brian,
I found the problem in the SQL Data Compare product but did duplicate the issue in the SQL Compare product. I can check the "Treat items as case sensitive" box under Behavior in the Opti...
I get the same results either way.
Thanks,
Dave / comments
I get the same results either way.
Thanks,
Dave
Brian,
I can get to the options tab and the 'ignore case' option is already checked.
Dave / comments
Brian,
I can get to the options tab and the 'ignore case' option is already checked.
Dave
SQL Logins Comparisions
I am getting the following error when I setup a project configuration and go from the Data Sources to Tables & Views tab (or any other tab):
Item has already been added. Key in dictionary: "BUBLIT...