platformaerp.com

Backup tabel

Procedura backupu danych przed wykonaniem operacji modyfikacji.

--safe copy
--create schema archive
declare @date varchar(13)  = format(getdate(), 'yyyyMMdd_HHmm')      --zyyyymmdd
exec ('select * into archive.documentline_'+@date +' from document.documentline')
exec ('select * into archive.document_'+@date +' from document.document')

Backup document.documenttype

--safe copy
--create schema archive
declare @date varchar(8)  =  convert(varchar, getdate(), 112)    --zyyyymmdd
exec ('select * into archive.documenttype_'+@date +' from document.documenttype')

declare @date varchar(13)  = format(getdate(), 'yyyyMMdd_HHmm')      --zyyyymmdd
exec ('select * into archive.dictionary_'+@date +' from common.dictionary ')