Delete UserOptions macht Export Pläne schneller.sql

aus File "delete_UserOptions__macht_Export_Pläne_schneller.sql"

ACHTUNG - Nach Ausführung dieses Skripts die Datenbank nicht mehr für einen AXML-Export verwenden, da die Nebeneffekte unbekannt sind.

delete from DANStationUser where IdUserUsername not like 'BIT %';
delete from DANStationUserPrintOptionen where IdStationUserUserUsername not like 'BIT %';
delete from DANStationUserSuSp where IdSchemaStationUserUserUsernam not like 'BIT %';
delete from DANStationUserSuSpSchema where IdStationUserUserUsername not like 'BIT %';
delete from DANUser where IdUsername not like 'BIT %';
delete from DANUserOption where IdUserUsername not like 'BIT %';
delete from DANUserPrivileg where IdUserUsername not like 'BIT %';
commit;

zurück zu V70Datenmigration