Works in debug mode, does not when i run without debug
hemantgaur
Posts: 27
Hi,
I had a question. When I try to synchronize a table, it works when I run in debug mode (F5) but does not when I run it without debug (Ctrl F5). Following is the SQL generated in run mode when I call block.GetString method.
please note that no inserts updates or delete SQL statements are generated between BEGIN TRANSACTION and COMMIT TRANSACTION.
Works perfectly in debug mode.
Please help as soon as possible. Thank You!!
*********************************
Script created by SQL Data Compare version 7.1.0.230 from Red Gate Software Ltd at 12/16/2009 15:23:06
Run this script on meckcamadev\sql2k5dev.cama_apro2009_shell
This script will make changes to meckcamadev\sql2k5dev.cama_apro2009_shell to make it the same as meckcamadev\sql2k5dev.cama_apro2009_source
Note that this script will carry out all DELETE commands for all tables first, then all the UPDATES and then all the INSERTS
It will disable foreign key constraints at the beginning of the script, and re-enable them at the end
*/
SET NUMERIC_ROUNDABORT OFF
GO
SET XACT_ABORT, ANSI_PADDING, ANSI_WARNINGS, CONCAT_NULL_YIELDS_NULL, ARITHABORT, QUOTED_IDENTIFIER, ANSI_NULLS, NOCOUNT ON
GO
SET DATEFORMAT YMD
GO
-- Pointer used for text / image updates. This might not be needed, but is declared here just in case
DECLARE @pv binary(16)
BEGIN TRANSACTION
COMMIT TRANSACTION
GO
*********************************
I had a question. When I try to synchronize a table, it works when I run in debug mode (F5) but does not when I run it without debug (Ctrl F5). Following is the SQL generated in run mode when I call block.GetString method.
please note that no inserts updates or delete SQL statements are generated between BEGIN TRANSACTION and COMMIT TRANSACTION.
Works perfectly in debug mode.
Please help as soon as possible. Thank You!!
*********************************
Script created by SQL Data Compare version 7.1.0.230 from Red Gate Software Ltd at 12/16/2009 15:23:06
Run this script on meckcamadev\sql2k5dev.cama_apro2009_shell
This script will make changes to meckcamadev\sql2k5dev.cama_apro2009_shell to make it the same as meckcamadev\sql2k5dev.cama_apro2009_source
Note that this script will carry out all DELETE commands for all tables first, then all the UPDATES and then all the INSERTS
It will disable foreign key constraints at the beginning of the script, and re-enable them at the end
*/
SET NUMERIC_ROUNDABORT OFF
GO
SET XACT_ABORT, ANSI_PADDING, ANSI_WARNINGS, CONCAT_NULL_YIELDS_NULL, ARITHABORT, QUOTED_IDENTIFIER, ANSI_NULLS, NOCOUNT ON
GO
SET DATEFORMAT YMD
GO
-- Pointer used for text / image updates. This might not be needed, but is declared here just in case
DECLARE @pv binary(16)
BEGIN TRANSACTION
COMMIT TRANSACTION
GO
*********************************
Comments
This could be a licensing issue. Are you evaluating the SDK, or do you have a license?
Can you make sure you have a valid licenses.licx file in your project and you have activates the tool?
http://www.red-gate.com/supportcenter/C ... c68944.htm