Skip to content
logo
platformaerp.com

Backup tabel SAFE COPY

Procedura backupu danych przed wykonaniem operacji modyfikacji.

Gotowe przykłady:

SQL
1
2
3
4
-- MAGAZYN document.document, document.documentline
declare @date varchar(13)  = format(getdate(), 'yyyyMMdd_HHmm')
exec ('select * into archive.documentline_'+@date +' from document.documentline')
exec ('select * into archive.document_'+@date +' from document.document')
SQL
1
2
3
4
5
-- FAKTURY document.invoice, document.invoiceline, document.invoiceksef
declare @date varchar(13)  = format(getdate(), 'yyyyMMdd_HHmm')     
exec ('select * into archive.invoice_'+@date +' from document.invoice')
exec ('select * into archive.invoiceline_'+@date +' from document.invoiceline')
exec ('select * into archive.invoiceksef_'+@date +' from document.invoiceksef')
SQL
1
2
3
4
5
6
-- KONFIGURACJE document.documenttype, common.dictionary, configuration.configuration, configuration.printout
declare @date varchar(8)  =  convert(varchar, getdate(), 112)
exec ('select * into archive.documenttype_'+@date +' from document.documenttype')
exec ('select * into archive.dictionary_'+@date +' from common.dictionary ')
exec ('select * into archive.configuration_'+@date +' from configuration.configuration')
exec ('select * into archive.printout_'+@date +' from configuration.printout')