随着我国电子商务的不断发展,基于B—S结构、数据量动辄百万级的大型网站不断涌现。为保证网站效率,需要及时对数据库内的数据进行存贮、备份、导出工作。山东关贸网(以下简称关贸网)是山东电子口岸的门户网站,是山东地区口岸物流信息化的统一平台。本文从关贸网的实际应用情况出发,利用Microsoft SQL Server 2000的数据复制、备份、导入导出的技术,通过综合分析各种因素,提出了关贸网数据导出系统的建议方案,同时对将来的关贸网数据仓库建设提出了意 With the continuous development of e-commerce in our country, based on the B-S structure, large-scale websites whose data volumes are often millions are constantly emerging. In order to ensure website efficiency, the data in the database needs to be stored, backed up and exported in time. Shandong Customs Network (hereinafter referred to as Gateway) is the port of Shandong electronic portals, port logistics information in Shandong unified platform. Based on the practical application of Customs and Trade Network, this paper makes use of Microsoft SQL Server 2000 data replication, backup, import and export technology, through the comprehensive analysis of various factors, Customs network construction of data warehouse made its point