FARONICS CORE - MIGRATION GUIDE 11-2009 Manual - page 21
Database Event Migration
|
21
Faronics Core Migration Guide
Manual Migration of Database Events
Once the database is restored, the following SQL statement can be used to move the historic log
event data from one database to the other (if you do not want to move the data using the Faronics
Core Migration Tool). This command assumes both databases exist in the same instance of SQL
and that the appropriate rights exist to move the data between both databases.
insert into FaronicsCore.dbo.tbl_LogEvents
(MachineId, ActionEventId, ProductId, LogTime, ExtraDataGuid)
(select MachineId, ActionEventId, ProductId, LogTime, ExtraDataGuid
from FaronicsEnterpriseDatabase.dbo.tbl_LogEvents)
DBCC DBREINDEX(tbl_logEvents)
insert into FaronicsCore.dbo.tbl_LogExtraData
(ExtraDataGuid, XMLData)
(select ExtraDataGuid, XMLData from
FaronicsEnterpriseDatabase.dbo.tbl_LogExtraData)
DBCC DBREINDEX(tbl_logExtraData)