Comments
Sort by recent activity
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...
Hi Peter,
I checked the log. But there was no warning message.
After more testing I found out when "Copy backup to network" option does not work.
If "Check backup files" option is checked "Copy backup to network" does not work. / comments
Hi Peter,
I checked the log. But there was no warning message.
After more testing I found out when "Copy backup to network" option does not work.
If "Check backup files" option is checked "Copy bac...
It would be nice to be able to see a list of backup files for the selected database. The user should be able to restore from a selected backup in the list.
The user should also be able to maintain/manage the backups i.e. change location, delete the backup etc.
A log for when the backup was restored.
This would be really handy.
This can be shown in a grid in a separate tab. / comments
It would be nice to be able to see a list of backup files for the selected database. The user should be able to restore from a selected backup in the list.
The user should also be able to maintain/...
Deleting the registry key worked for me too. But now I am getting "Trial Expired". I cannot run SQL Prompt. / comments
Deleting the registry key worked for me too. But now I am getting "Trial Expired". I cannot run SQL Prompt.
I am having the same problem. I have uninstalled SQL Prompt 2. I am running this on Windows XP Pro. / comments
I am having the same problem. I have uninstalled SQL Prompt 2. I am running this on Windows XP Pro.
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...