Activity overview
Latest activity by phispher
I guess I'm just looking for some convenience when it comes to the logs as I get them. It's nice to have notification via log file when errors occur, but it if were more finite in it's reporting, it would make it ever better. If it were configurable on some level, so you could decide what type of data you see (i.e. Failures, Successes, both, etc.) then it would allow us to choose what we saw. In my opinion, that could be very useful for us busy DBA's who don't have a lot of time to parse a log file all the way through looking for a single error. / comments
I guess I'm just looking for some convenience when it comes to the logs as I get them. It's nice to have notification via log file when errors occur, but it if were more finite in it's reporting, ...
SQL Backup Error Log
Hi! I have SQL Backup 5 Professional edition installed on several prod servers here and have the jobs configued to email me a log when errors occur. However, it's quite painful to have to navigat...
DBCC Integrity checking and SQL Backup
Does SQL Backup include some type of integrity checking before database backups occur? If no, would there be some easy way of implementing it aside from adding the T-SQL code to the job that runs ...
Here is a line i pulled from the sync script:
INSERT INTO [dbo].[DATA_FLOAT] ([data_float_id], [data_float], [_temp_data_float_id]) VALUES (25555, -97.39872, NULL)
So, as you can see, the sync script is truncating it too. / comments
Here is a line i pulled from the sync script:
INSERT INTO [dbo].[DATA_FLOAT] ([data_float_id], [data_float], [_temp_data_float_id]) VALUES (25555, -97.39872, NULL)
So, as you can see, the sync scri...
FLOAT issue with SQL Data Compare 5
I have searched in vain for a resolution to this problem. Let me set the stage first. I have a table in SQL with a float column. I used Query Analyzer to query a value and I get:
-97.39871999999...
Hi,
I played with the options in the UI for a little bit and found an optimum configuration that worked for me.
mappings.Options = new EngineDataCompareOptions(
MappingOptions.IgnoreCase | MappingOptions.IgnoreSpaces |
MappingOptions.IncludeIndexedViews | MappingOptions.IncludeIdentities |
MappingOptions.IncludeTimestamps,
ComparisonOptions.Default,
SqlOptions.DisableKeys| SqlOptions.UseTransactions)
Thanks for your quick response, if I see any other issues, I'll post them here. / comments
Hi,
I played with the options in the UI for a little bit and found an optimum configuration that worked for me.
mappings.Options = new EngineDataCompareOptions(
MappingOptions.IgnoreCase | MappingO...
NTEXT issues with SQL Data Compare
Hi,
I'm getting the following error when attempting to synchronize between two databases with exactly the same schema using the SQL Data Compare API:
System.Data.SqlClient.SqlException: Page (1:723...