Gestione dossier
Jump to navigation
Jump to search
Gestione dossier[edit]
Eliminazione dossier[edit]
Detto ZZZ il nome del dossier da eliminare:
- Da GESADS selezionare il dossier ZZZ e cliccare sul pulsante Elimina
- Andare sul server applicativo (srvx3), nella cartella Folders (C:\SAGE\SAGEX3V6\X3V6\Folders)
- rimuovere la cartella ZZZ
- rimuovere la cartella X3_PUB\ZZZ
- Eseguire i comandi sql seguenti (per connettersi il nome istanza è SERVER\X3V6):
use [x3v6] DECLARE @table_schema varchar(100) ,@table_name varchar(100) ,@constraint_schema varchar(100) ,@constraint_name varchar(100) ,@cmd nvarchar(200) -- Inserire il nome dello schema da eliminare SET @table_schema = 'TEST' -- -- drop all VIEW -- DECLARE @table_cursor CURSOR SET @table_cursor = CURSOR FOR select TABLE_NAME from INFORMATION_SCHEMA.TABLES where TABLE_TYPE = 'VIEW' and TABLE_SCHEMA = @table_schema order by TABLE_NAME OPEN @table_cursor FETCH NEXT FROM @table_cursor INTO @table_name print 'elimino viste' WHILE @@FETCH_STATUS = 0 BEGIN SELECT @cmd = 'DROP TABLE [' + @table_schema + '].[' + @table_name + ']' print @cmd --EXEC sp_executesql @cmd FETCH NEXT FROM @table_cursor INTO @table_name END CLOSE @table_cursor DEALLOCATE @table_cursor -- -- drop all TABLE -- SET @table_cursor = CURSOR FOR select TABLE_NAME from INFORMATION_SCHEMA.TABLES where TABLE_TYPE = 'BASE TABLE' and TABLE_SCHEMA = @table_schema order by TABLE_NAME OPEN @table_cursor FETCH NEXT FROM @table_cursor INTO @table_name print 'Elimino TAbelle' WHILE @@FETCH_STATUS = 0 BEGIN SELECT @cmd = 'DROP TABLE [' + @table_schema + '].[' + @table_name + ']' print @cmd --EXEC sp_executesql @cmd FETCH NEXT FROM @table_cursor INTO @table_name END CLOSE @table_cursor DEALLOCATE @table_cursor -- -- Cancellazione Schema -- SELECT @cmd = 'DROP SCHEMA ' + @table_schema --EXEC sp_executesql @cmd
Eseguire le cancellazione seguenti:
select * from X3.ADOSACT where DOSSIER_0 like 'TEST%' delete X3.ADOSACT where DOSSIER_0 like 'TEST%' select * from X3.ADOSDIM where DOSSIER_0 like 'TEST%' delete X3.ADOSDIM where DOSSIER_0 like 'TEST%' select * from dbo.SS_SEQUENCE where usr like 'TEST%' delete dbo.SS_SEQUENCE where usr like 'TEST%'