目录 手动BCP文件备份与恢复............................................................................................................. 2 一、备份前的准备 ....................................................................................................................... 2 1.数据库日常备份 .................................................................................................................... 2 2.数据库迁移 ............................................................................................................................ 2 二、备份数据 ............................................................................................................................... 2 1. 将备份目录下的zx_zgstru.sql、zx_index.sql 和 zxcon.sql 文件复制到运行软件目录下: .................................................................................................................................................. 5 2.利用sybase central,建立一个新数据库,数据库名可以为正式数据库后加上new ..... 5 3.在运行软件目录中,修改wgz_mdb.txt 文件,添加新数据库记录,保存后双击应用程序图标用2000/2000 登录号和口令进入空数据库: ............................................................ 6 4.在DOS 下运行zgbcp.bat 恢复数据 .................................................................................. 6 5.检查指定目录下打开bcplog.txt 文档 ............................................................................... 7 6.以正常口令进入软件,数据库升级两次; ..................................................................... 8 7.运行zgcon.sql 文件: ........................................................................................................... 8 8.检查数据库一致性: ......................................................................................................... 8 9.正常登录,进行数据库升级(操作同第8 步,可选); ..................................................... 9 1 系统基本设置核对(可选) ....