Samuele E. Locatelli
85 lines
9.0 KiB
Transact-SQL
85 lines
9.0 KiB
Transact-SQL
/*
|
|
Run this script on:
|
|
|
|
SRV-PRODTK01.TK_GMWTestSW - This database will be modified
|
|
|
|
to synchronize it with:
|
|
|
|
T110-WIN2008R2\SQL2008R2.TK_GMWTest
|
|
|
|
You are recommended to back up your database before running this script
|
|
|
|
Script created by SQL Data Compare version 8.1.0 from Red Gate Software Ltd at 06/06/2012 13.44.03
|
|
|
|
*/
|
|
|
|
SET NUMERIC_ROUNDABORT OFF
|
|
GO
|
|
SET ANSI_PADDING, ANSI_WARNINGS, CONCAT_NULL_YIELDS_NULL, ARITHABORT, QUOTED_IDENTIFIER, ANSI_NULLS, NOCOUNT ON
|
|
GO
|
|
SET DATEFORMAT YMD
|
|
GO
|
|
SET XACT_ABORT ON
|
|
GO
|
|
SET TRANSACTION ISOLATION LEVEL SERIALIZABLE
|
|
GO
|
|
BEGIN TRANSACTION
|
|
-- Pointer used for text / image updates. This might not be needed, but is declared here just in case
|
|
DECLARE @pv binary(16)
|
|
|
|
-- Drop constraints from [dbo].[Soggetti2Utente]
|
|
ALTER TABLE [dbo].[Soggetti2Utente] DROP CONSTRAINT [FK_Soggetti2Utente_AnagOperatori]
|
|
|
|
-- Update 31 rows in [dbo].[TabSyncMovMag]
|
|
UPDATE [dbo].[TabSyncMovMag] SET [codMagExtTo]=N'0' WHERE [CodCS]=N'SP' AND [CodStatoFrom]=N'FinGBox' AND [CodStatoTo]=N'DEL' AND [IdxPosizioneFrom]=4 AND [IdxPosizioneTo]=0
|
|
UPDATE [dbo].[TabSyncMovMag] SET [codMagExtFrom]=N'4', [codMagExtTo]=N'4' WHERE [CodCS]=N'SP' AND [CodStatoFrom]=N'FinGBox' AND [CodStatoTo]=N'FinGBox' AND [IdxPosizioneFrom]=-4 AND [IdxPosizioneTo]=4
|
|
UPDATE [dbo].[TabSyncMovMag] SET [codMagExtFrom]=N'4', [codMagExtTo]=N'4' WHERE [CodCS]=N'SP' AND [CodStatoFrom]=N'FinGBox' AND [CodStatoTo]=N'FinGBox' AND [IdxPosizioneFrom]=4 AND [IdxPosizioneTo]=-4
|
|
UPDATE [dbo].[TabSyncMovMag] SET [note]=N'MODIFICHE quantità' WHERE [CodCS]=N'SP' AND [CodStatoFrom]=N'FinGBox' AND [CodStatoTo]=N'FinGBox' AND [IdxPosizioneFrom]=4 AND [IdxPosizioneTo]=4
|
|
UPDATE [dbo].[TabSyncMovMag] SET [codMagExtFrom]=N'4', [codMagExtTo]=N'0' WHERE [CodCS]=N'SP' AND [CodStatoFrom]=N'FinGBox' AND [CodStatoTo]=N'FinGBox' AND [IdxPosizioneFrom]=4 AND [IdxPosizioneTo]=200
|
|
UPDATE [dbo].[TabSyncMovMag] SET [codMagExtFrom]=N'0', [codMagExtTo]=N'4' WHERE [CodCS]=N'SP' AND [CodStatoFrom]=N'FinGBox' AND [CodStatoTo]=N'FinGBox' AND [IdxPosizioneFrom]=200 AND [IdxPosizioneTo]=4
|
|
UPDATE [dbo].[TabSyncMovMag] SET [codMagExtTo]=N'0' WHERE [CodCS]=N'SP' AND [CodStatoFrom]=N'FinLiq' AND [CodStatoTo]=N'DEL' AND [IdxPosizioneFrom]=4 AND [IdxPosizioneTo]=0
|
|
UPDATE [dbo].[TabSyncMovMag] SET [note]=N'MODIFICHE quantità' WHERE [CodCS]=N'SP' AND [CodStatoFrom]=N'FinLiq' AND [CodStatoTo]=N'FinLiq' AND [IdxPosizioneFrom]=4 AND [IdxPosizioneTo]=4
|
|
UPDATE [dbo].[TabSyncMovMag] SET [codMagExtFrom]=N'4', [codMagExtTo]=N'0' WHERE [CodCS]=N'SP' AND [CodStatoFrom]=N'FinLiq' AND [CodStatoTo]=N'FinLiq' AND [IdxPosizioneFrom]=4 AND [IdxPosizioneTo]=200
|
|
UPDATE [dbo].[TabSyncMovMag] SET [codMagExtFrom]=N'0', [codMagExtTo]=N'4' WHERE [CodCS]=N'SP' AND [CodStatoFrom]=N'FinLiq' AND [CodStatoTo]=N'FinLiq' AND [IdxPosizioneFrom]=200 AND [IdxPosizioneTo]=4
|
|
UPDATE [dbo].[TabSyncMovMag] SET [codMagExtFrom]=N'0' WHERE [CodCS]=N'SP' AND [CodStatoFrom]=N'MP' AND [CodStatoTo]=N'MP' AND [IdxPosizioneFrom]=-6 AND [IdxPosizioneTo]=6
|
|
UPDATE [dbo].[TabSyncMovMag] SET [codMagExtTo]=N'0' WHERE [CodCS]=N'SP' AND [CodStatoFrom]=N'MP' AND [CodStatoTo]=N'MP' AND [IdxPosizioneFrom]=6 AND [IdxPosizioneTo]=-6
|
|
UPDATE [dbo].[TabSyncMovMag] SET [codMagExtFrom]=N'0' WHERE [CodCS]=N'SP' AND [CodStatoFrom]=N'NEW' AND [CodStatoTo]=N'FinGBox' AND [IdxPosizioneFrom]=0 AND [IdxPosizioneTo]=4
|
|
UPDATE [dbo].[TabSyncMovMag] SET [codMagExtFrom]=N'0' WHERE [CodCS]=N'SP' AND [CodStatoFrom]=N'NEW' AND [CodStatoTo]=N'FinLiq' AND [IdxPosizioneFrom]=0 AND [IdxPosizioneTo]=4
|
|
UPDATE [dbo].[TabSyncMovMag] SET [codMagExtFrom]=N'0' WHERE [CodCS]=N'SP' AND [CodStatoFrom]=N'NEW' AND [CodStatoTo]=N'MP' AND [IdxPosizioneFrom]=0 AND [IdxPosizioneTo]=6
|
|
UPDATE [dbo].[TabSyncMovMag] SET [codMagExtFrom]=N'-2' WHERE [CodCS]=N'TK' AND [CodStatoFrom]=N'Anim' AND [CodStatoTo]=N'Anim' AND [IdxPosizioneFrom]=-2 AND [IdxPosizioneTo]=2
|
|
UPDATE [dbo].[TabSyncMovMag] SET [codMagExtTo]=N'-2' WHERE [CodCS]=N'TK' AND [CodStatoFrom]=N'Anim' AND [CodStatoTo]=N'Anim' AND [IdxPosizioneFrom]=2 AND [IdxPosizioneTo]=-2
|
|
UPDATE [dbo].[TabSyncMovMag] SET [note]=N'MODIFICHE quantità' WHERE [CodCS]=N'TK' AND [CodStatoFrom]=N'Anim' AND [CodStatoTo]=N'Anim' AND [IdxPosizioneFrom]=2 AND [IdxPosizioneTo]=2
|
|
UPDATE [dbo].[TabSyncMovMag] SET [codMagExtTo]=N'0' WHERE [CodCS]=N'TK' AND [CodStatoFrom]=N'Anim' AND [CodStatoTo]=N'DEL' AND [IdxPosizioneFrom]=2 AND [IdxPosizioneTo]=0
|
|
UPDATE [dbo].[TabSyncMovMag] SET [toExt]=1, [codMagExtFrom]=N'-2' WHERE [CodCS]=N'TK' AND [CodStatoFrom]=N'AnimExt' AND [CodStatoTo]=N'AnimExt' AND [IdxPosizioneFrom]=-2 AND [IdxPosizioneTo]=2
|
|
UPDATE [dbo].[TabSyncMovMag] SET [toExt]=1, [codMagExtTo]=N'-2' WHERE [CodCS]=N'TK' AND [CodStatoFrom]=N'AnimExt' AND [CodStatoTo]=N'AnimExt' AND [IdxPosizioneFrom]=2 AND [IdxPosizioneTo]=-2
|
|
UPDATE [dbo].[TabSyncMovMag] SET [note]=N'MODIFICHE quantità: NO perchè carico da bolla' WHERE [CodCS]=N'TK' AND [CodStatoFrom]=N'AnimExt' AND [CodStatoTo]=N'AnimExt' AND [IdxPosizioneFrom]=2 AND [IdxPosizioneTo]=2
|
|
UPDATE [dbo].[TabSyncMovMag] SET [codMagExtFrom]=N'0', [note]=N'MODIFICO da 2222 a 2 - vecchio giro' WHERE [CodCS]=N'TK' AND [CodStatoFrom]=N'AnimExt' AND [CodStatoTo]=N'AnimExt' AND [IdxPosizioneFrom]=2222 AND [IdxPosizioneTo]=2
|
|
UPDATE [dbo].[TabSyncMovMag] SET [codMagExtFrom]=N'2', [codMagExtTo]=N'0' WHERE [CodCS]=N'TK' AND [CodStatoFrom]=N'AnimExt' AND [CodStatoTo]=N'DEL' AND [IdxPosizioneFrom]=2 AND [IdxPosizioneTo]=0
|
|
UPDATE [dbo].[TabSyncMovMag] SET [codMagExtFrom]=N'0', [codMagExtTo]=N'0' WHERE [CodCS]=N'TK' AND [CodStatoFrom]=N'AnimExt' AND [CodStatoTo]=N'DEL' AND [IdxPosizioneFrom]=2222 AND [IdxPosizioneTo]=0
|
|
UPDATE [dbo].[TabSyncMovMag] SET [codMagExtFrom]=N'0', [codMagExtTo]=N'6', [note]=N'ANNULLO CONSUMO MP NON riporto a sistema ext' WHERE [CodCS]=N'TK' AND [CodStatoFrom]=N'MP' AND [CodStatoTo]=N'MP' AND [IdxPosizioneFrom]=-6 AND [IdxPosizioneTo]=6
|
|
UPDATE [dbo].[TabSyncMovMag] SET [codMagExtFrom]=N'6', [codMagExtTo]=N'6' WHERE [CodCS]=N'TK' AND [CodStatoFrom]=N'MP' AND [CodStatoTo]=N'MP' AND [IdxPosizioneFrom]=6 AND [IdxPosizioneTo]=-6
|
|
UPDATE [dbo].[TabSyncMovMag] SET [codMagExtFrom]=N'0' WHERE [CodCS]=N'TK' AND [CodStatoFrom]=N'NEW' AND [CodStatoTo]=N'Anim' AND [IdxPosizioneFrom]=0 AND [IdxPosizioneTo]=2
|
|
UPDATE [dbo].[TabSyncMovMag] SET [codMagExtFrom]=N'0' WHERE [CodCS]=N'TK' AND [CodStatoFrom]=N'NEW' AND [CodStatoTo]=N'AnimExt' AND [IdxPosizioneFrom]=0 AND [IdxPosizioneTo]=2
|
|
UPDATE [dbo].[TabSyncMovMag] SET [codMagExtFrom]=N'0', [codMagExtTo]=N'0' WHERE [CodCS]=N'TK' AND [CodStatoFrom]=N'NEW' AND [CodStatoTo]=N'AnimExt' AND [IdxPosizioneFrom]=0 AND [IdxPosizioneTo]=2222
|
|
UPDATE [dbo].[TabSyncMovMag] SET [codMagExtFrom]=N'0' WHERE [CodCS]=N'TK' AND [CodStatoFrom]=N'NEW' AND [CodStatoTo]=N'MP' AND [IdxPosizioneFrom]=0 AND [IdxPosizioneTo]=6
|
|
|
|
-- Update 1 row in [dbo].[Soggetti2Utente]
|
|
UPDATE [dbo].[Soggetti2Utente] SET [DOMINIO]='VOSTRO410' WHERE [CodSoggetto]=N'O9900000000000005' AND [USER_NAME]=N'Administrator'
|
|
|
|
-- Add 1 row to [dbo].[ElencoPostazioni]
|
|
INSERT INTO [dbo].[ElencoPostazioni] ([codPostazione], [stampante]) VALUES (N'WIN7-VM1', N'\\vostro410\PDFCreator')
|
|
|
|
-- Add 7 rows to [dbo].[TabSyncMovMag]
|
|
INSERT INTO [dbo].[TabSyncMovMag] ([CodCS], [CodStatoFrom], [CodStatoTo], [IdxPosizioneFrom], [IdxPosizioneTo], [toExt], [codMagExtFrom], [codMagExtTo], [codMagExtComp], [note]) VALUES (N'TK', N'Anim', N'Anim', 2, 300, 0, N'0', N'0', N'0', N'')
|
|
INSERT INTO [dbo].[TabSyncMovMag] ([CodCS], [CodStatoFrom], [CodStatoTo], [IdxPosizioneFrom], [IdxPosizioneTo], [toExt], [codMagExtFrom], [codMagExtTo], [codMagExtComp], [note]) VALUES (N'TK', N'AnimExt', N'AnimExt', 2, 300, 0, N'0', N'0', N'0', N'')
|
|
INSERT INTO [dbo].[TabSyncMovMag] ([CodCS], [CodStatoFrom], [CodStatoTo], [IdxPosizioneFrom], [IdxPosizioneTo], [toExt], [codMagExtFrom], [codMagExtTo], [codMagExtComp], [note]) VALUES (N'TK', N'AnimExt', N'AnimExt', 300, 2, 0, N'0', N'0', N'0', N'')
|
|
INSERT INTO [dbo].[TabSyncMovMag] ([CodCS], [CodStatoFrom], [CodStatoTo], [IdxPosizioneFrom], [IdxPosizioneTo], [toExt], [codMagExtFrom], [codMagExtTo], [codMagExtComp], [note]) VALUES (N'TK', N'MP', N'DEL', 6, 0, 0, N'6', N'0', NULL, N'CANCELLO UDC MP')
|
|
INSERT INTO [dbo].[TabSyncMovMag] ([CodCS], [CodStatoFrom], [CodStatoTo], [IdxPosizioneFrom], [IdxPosizioneTo], [toExt], [codMagExtFrom], [codMagExtTo], [codMagExtComp], [note]) VALUES (N'TK', N'MP', N'MP-NA', 6, 6, 0, N'6', N'6', NULL, N'CAMBIO Stato MP a MP non Accettata')
|
|
INSERT INTO [dbo].[TabSyncMovMag] ([CodCS], [CodStatoFrom], [CodStatoTo], [IdxPosizioneFrom], [IdxPosizioneTo], [toExt], [codMagExtFrom], [codMagExtTo], [codMagExtComp], [note]) VALUES (N'TK', N'MP-NA', N'MP', 6, 6, 0, N'6', N'6', NULL, N'CAMBIO Stato MP non Accettata a MP accettata')
|
|
INSERT INTO [dbo].[TabSyncMovMag] ([CodCS], [CodStatoFrom], [CodStatoTo], [IdxPosizioneFrom], [IdxPosizioneTo], [toExt], [codMagExtFrom], [codMagExtTo], [codMagExtComp], [note]) VALUES (N'TK', N'MP-NA', N'MP-NA', 6, 6, 0, N'6', N'6', NULL, N'MODIFICA Quantità')
|
|
|
|
-- Add constraints to [dbo].[Soggetti2Utente]
|
|
ALTER TABLE [dbo].[Soggetti2Utente] WITH NOCHECK ADD CONSTRAINT [FK_Soggetti2Utente_AnagOperatori] FOREIGN KEY ([CodSoggetto]) REFERENCES [RilPro].[AnagOperatori] ([CodSoggetto]) ON UPDATE CASCADE
|
|
COMMIT TRANSACTION
|
|
GO
|