利用数据管道和嵌入式SQL语言实现数据在线备份  

Using Data Pipeline and Embedded SQL Statement to Backup Data Online

作　　者：张利民 邢小平 ZHANG Limin;XING Xiaoping(Shaoxing YINGNA Powder Coating Co.,Ltd.,Shengzhou Zhejiang 312455;Zhejiang MAYATA Precision Machinery Co.,Ltd.,Shengzhou Zhejiang 312455)

机构地区：[1]绍兴市英纳粉末涂料有限公司,浙江嵊州312455 [2]浙江美亚特精密机械有限公司,浙江嵊州312455

出　　处：《软件》2020年第11期202-204,共3页Software

摘　　要：尽管不同的BDMS提供有不同的数据备份方案,在通常情况下,数据备份均需断开应用连接,脱机进行,后台数据库支持会中断。另外,为了提供足够的备份安全,数据备份文件不应保存在同一主机系统中,在不同机器之间拷贝数据文件显得繁琐。若能用程序方法实现对数据库的在线备份,则是一种好的方法。本文介绍利用PB的Data Pipeline与SQL语句实现包括对BLOB字段数据库的在线备份设计方法。Data backup needs to be disconnected from the application and offl ine usually,though diff erent BDMS provide diff erent data backup solutions,background database support will be interrupted.In addition,in order to provide suffi cient security for database backup,data fi les should not be stored in the same host system,to copy data fi les between diff erent machines is cumbersome.It is a good way to back up the database online by programming.This paper introduces the design method of online backup of database(including blob column)by using PowerBuilder data pipeline and SQL statement.

关 键 词：数据管道 嵌入式SQL 数据备份 

分 类 号：TP319[自动化与计算机技术—计算机软件与理论]