Comments
Sort by recent activity
>Were you comparing live->live or backup->live or backup->backup or live->backup?
It was a live->live comparison.
>Did you have a saved project or was it ad-hoc?
It was a saved project.
>Had you clicked on the tables&views of the project configuration prior to attempting to re-map the object?
I do not remember but I may have changed the comparison key for objects that could not be compared.
>Were you looking at the tables grouped or in a list?
Grouped / comments
>Were you comparing live->live or backup->live or backup->backup or live->backup?
It was a live->live comparison.
>Did you have a saved project or was it ad-hoc?
It was a saved project.
>Had you cl...
This happened only once. I am trying to replicate it but it's not happening again. I was playing aroud with object which could not be compared when this happened. / comments
This happened only once. I am trying to replicate it but it's not happening again. I was playing aroud with object which could not be compared when this happened.
If you double click(right or left button) on the SQL script tab header that switches the synchronization direction. / comments
If you double click(right or left button) on the SQL script tab header that switches the synchronization direction.
Bug
While printing the column Type is not showing the value Table in full. i.e. "e" is being cut in half for the value "Table".
Also how do I print a report for the differences for a table comparision? / comments
Bug
While printing the column Type is not showing the value Table in full. i.e. "e" is being cut in half for the value "Table".
Also how do I print a report for the differences for a table comparis...
Is there any way to filter identical objects from appearing in the list and report. The only place this option is available is in the Export Comparison Results" window.
While printing a report I would like to view a list of object that failed the comparison. I do not have have a need of printing identical objects(would be just a waste of paper).
An option to filter identical objects would be useful. / comments
Is there any way to filter identical objects from appearing in the list and report. The only place this option is available is in the Export Comparison Results" window.
While printing a report I wo...
The object synchronization script is same for both the synchronization direction.
Here is the object synchronization script that was created by SQL Compare.
/*
Script created by SQL Compare version 6.0.0 from Red Gate Software Ltd at ---.
Run this script on --- to make it the same as ---
Please back up your database before running this script
*/
SET NUMERIC_ROUNDABORT OFF
GO
SET ANSI_PADDING, ANSI_WARNINGS, CONCAT_NULL_YIELDS_NULL, ARITHABORT, QUOTED_IDENTIFIER, ANSI_NULLS ON
GO
IF EXISTS (SELECT * FROM tempdb..sysobjects WHERE id=OBJECT_ID('tempdb..#tmpErrors')) DROP TABLE #tmpErrors
GO
CREATE TABLE #tmpErrors (Error int)
GO
SET XACT_ABORT ON
GO
SET TRANSACTION ISOLATION LEVEL SERIALIZABLE
GO
BEGIN TRANSACTION
GO
IF EXISTS (SELECT * FROM #tmpErrors) ROLLBACK TRANSACTION
GO
IF @@TRANCOUNT>0 BEGIN
PRINT 'The database update succeeded'
COMMIT TRANSACTION
END
ELSE PRINT 'The database update failed'
GO
DROP TABLE #tmpErrors
GO
/ comments
The object synchronization script is same for both the synchronization direction.
Here is the object synchronization script that was created by SQL Compare.
/*
Script created by SQL Compare versio...
Found the hidden columns. Maybe the Maximum time/Average time column can be used in summary for the 3 sections. / comments
Found the hidden columns. Maybe the Maximum time/Average time column can be used in summary for the 3 sections.
If the activity history is not for the given database the user should be able to delete/clear the activity history for that database. / comments
If the activity history is not for the given database the user should be able to delete/clear the activity history for that database.
Hi James,
I think if the drop is temporary then the database can be recreated using the restore(Browse for files) feature in SQL Backup. In the example that I had given if the dropped database "db1" is restored using a previous full backup in SQL Backup and the new database is also given the name "db1" then only Activity history should be linked with the new database.
Otherwise you will get the following error whenever you try to do a restore : -
SQL Server error
Server: Msg 3013
RESTORE DATABASE is terminating abnormally.
Server: Msg 3154
The backup set holds a backup of a database other than the existing 'db1' database.
SQL Backup exit code: 1100
SQL error code: 3154
/ comments
Hi James,
I think if the drop is temporary then the database can be recreated using the restore(Browse for files) feature in SQL Backup. In the example that I had given if the dropped database "db1...
How do I see activities in the timeline for a single database that I have selected in the tree? I am getting activities for the whole server in the timeline irrespective of the database I am selecting in the tree. / comments
How do I see activities in the timeline for a single database that I have selected in the tree? I am getting activities for the whole server in the timeline irrespective of the database I am select...