CN106095880A - Method for synchronizing data of inner network and outer network of sybase based on VB development - Google Patents
Method for synchronizing data of inner network and outer network of sybase based on VB development Download PDFInfo
- Publication number
- CN106095880A CN106095880A CN201610396201.7A CN201610396201A CN106095880A CN 106095880 A CN106095880 A CN 106095880A CN 201610396201 A CN201610396201 A CN 201610396201A CN 106095880 A CN106095880 A CN 106095880A
- Authority
- CN
- China
- Prior art keywords
- intranet
- data
- sybase
- extranet
- script
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
- 238000000034 method Methods 0.000 title claims abstract description 41
- 230000008676 import Effects 0.000 claims abstract description 13
- 230000001360 synchronised effect Effects 0.000 claims abstract description 5
- 238000012545 processing Methods 0.000 claims abstract description 4
- 238000009795 derivation Methods 0.000 claims description 12
- 230000008569 process Effects 0.000 claims description 12
- 238000012550 audit Methods 0.000 claims description 3
- 238000011017 operating method Methods 0.000 claims description 3
- 230000000007 visual effect Effects 0.000 abstract 1
- 230000005012 migration Effects 0.000 description 2
- 238000013508 migration Methods 0.000 description 2
- 230000008901 benefit Effects 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 239000004744 fabric Substances 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/27—Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
- G06F16/275—Synchronous replication
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q40/00—Finance; Insurance; Tax strategies; Processing of corporate or income taxes
Abstract
The invention discloses a method for synchronizing data of an inside network and an outside network of a sybase developed based on VB (visual basic). the method generates a batch processing script which needs to be synchronized to a database table through logic judgment, wherein the core content of the script is a bcp import and export command of the sybase; and configuring a timing plan task by executing the script, and synchronizing data. The invention realizes the automatic synchronization of the invoice data from the internal network to the external network by configuring the timing task, thereby greatly improving the working efficiency.
Description
Technical field
The present invention relates to database technical field, be specifically related to a kind of sybase storehouse intranet and extranet data based on VB exploitation same
The method of step, is mainly used in sybase storehouse intranet data to be synchronized in outer net.
Background technology
Land tax Intranet encourages system by cloth, generates quota invoice data information with lottery, writes Intranet sybase data base, raw
Become to print plan, print to printing house.Then, after needing these invoice information (code, number, password) to be synchronized to outer net, receive
Tax people could carry out true and false inquiry by the Internet to these invoices.
Can enough provide a machine to be simultaneously connected with Intranet and outer net in view of the tax bureau, drop for large data volume table efficiency
Low, it is impossible to not have the table of rule to build table migration table name, field name, it is impossible to the problems such as migration, so needing an energy timing
The method performed, realizes invoice information data (sybase data base's invoice information table) by Intranet automatic synchronization to outer net.
Summary of the invention
The technical problem to be solved in the present invention is: for problem above, and the present invention provides sybase storehouse based on VB exploitation
The method of intranet and extranet data syn-chronization, is mainly used in sybase storehouse intranet data to be synchronized in outer net.
The technical solution adopted in the present invention is:
The method of sybase storehouse intranet and extranet data syn-chronization based on VB exploitation, described method is passed through logical judgment, is generated needs same
Step is to the batch processing script of database table, and the core content of described script is that the bcp of sybase imports and exports order；By holding
The described script of row, configuration timing plan target, carry out data syn-chronization.
Described method operating procedure is as follows:
1) configuration connects intranet and extranet data source drive connection, it is judged that intranet and extranet database connectivity situation also writes log sheet；
2) read Intranet invoice table set, then judge whether outer net exists vocabulary, if it does not exist, then according to table name, field
Name outer net creates invoice table；
3) generate the derivation of data Intranet according to the bcp order of sybase storehouse, outer net imports autoexec；
4) the autoexec execution data importing that execution is generated is transferred.
It is as follows that described method realizes flow process:
1) obtain intranet and extranet data base OBDC and connect source；
2) judge that intranet and extranet data base OBDC connects；
3) if the most all connected, misregistration daily record, flow process terminates；
4) if all connected, intranet data table name and outer net data table name are read；
5) judge that internal, external network data table name is the most consistent；
6) as inconsistent in internal, external network data table name, create the non-existent tables of data of outer net, generate derivation, import script；
7) as consistent in internal, external network data table name, then generate derivation, import script；
8) script generated is performed；
9) derivation data file is deleted；
10) flow process terminates.
Described flow process is program by VB exploitation, and vb program is easily achieved these above-mentioned technical problems, generates exe file
Small routine.
Described program is timed scheduling by configuring plan target, it is achieved data automatic synchronization.
Described method, by setting up and audit log table, checks that synchronization the most normally performs.
The invention have the benefit that
The present invention realizes invoice data from Intranet automatic synchronization to outer net by configuring timing tasks, thus greatly improves work
Make efficiency.
Accompanying drawing explanation
Fig. 1 is the log sheet that the inventive method relates to；
Fig. 2 is the inventive method flow chart.
Detailed description of the invention
Below in conjunction with Figure of description, by detailed description of the invention, the present invention is further described:
Embodiment 1:
The method of sybase storehouse intranet and extranet data syn-chronization based on VB exploitation, described method is passed through logical judgment, is generated needs same
Step is to the batch processing script of database table, and the core content of described script is that the bcp of sybase imports and exports order；By holding
The described script of row, configuration timing plan target, carry out data syn-chronization.
Embodiment 2:
On the basis of embodiment 1, described in the present embodiment, method operating procedure is as follows:
1) configuration connects intranet and extranet data source drive connection, it is judged that intranet and extranet database connectivity situation also writes log sheet；
2) read Intranet invoice table set, then judge whether outer net exists vocabulary, if it does not exist, then according to table name, field
Name outer net creates invoice table；
3) generate the derivation of data Intranet according to the bcp order of sybase storehouse, outer net imports autoexec；
4) the autoexec execution data importing that execution is generated is transferred.
Embodiment 3:
As in figure 2 it is shown, on the basis of embodiment 2, it is as follows that method described in the present embodiment realizes flow process:
1) obtain intranet and extranet data base OBDC and connect source；
2) judge that intranet and extranet data base OBDC connects；
3) if the most all connected, misregistration daily record, flow process terminates；
4) if all connected, intranet data table name and outer net data table name are read；
5) judge that internal, external network data table name is the most consistent；
6) as inconsistent in internal, external network data table name, create the non-existent tables of data of outer net, then generate derivation, import script；
7) as consistent in internal, external network data table name, then directly generate derivation, import script；
8) script generated is performed；
9) derivation data file is deleted；
10) flow process terminates.
Wherein tables of data import, derive scripted code as follows:
bcp czdj..T_232040603010 out e:\bak\temp\232040603010.txt -Usa –Psybase
-Snwdbserver -c
isql –Usa –Psybase -Swwcxserver –i e:\bak\temp\232040603010.sql
bcp wwcx..T_232040603010 in e:\bak\temp\232040601030.txt -Usa –Psybase
-Swwcxserver -c
del e:\bak\temp\232040603010.txt
Embodiment 4:
On the basis of embodiment 3, flow process described in the present embodiment is program by VB exploitation, and vb program is easily achieved these
Above-mentioned technical problem, generates the small routine of exe file.
Embodiment 5:
On the basis of embodiment 4, program described in the present embodiment is timed scheduling by configuring plan target, it is achieved data are certainly
Dynamic synchronization.
Embodiment 6:
As it is shown in figure 1, on the basis of any embodiment 3,4 or 5, method described in the present embodiment is by setting up and audit log
Table, checks that synchronization the most normally performs.
Embodiment of above is merely to illustrate the present invention, and not limitation of the present invention, common about technical field
Technical staff, without departing from the spirit and scope of the present invention, it is also possible to make a variety of changes and modification, therefore own
The technical scheme of equivalent falls within scope of the invention, and the scope of patent protection of the present invention should be defined by the claims.
Claims (6)
1. the method for sybase storehouse intranet and extranet data syn-chronization based on VB exploitation, it is characterised in that: described method is sentenced by logic
Disconnected, generate and need to be synchronized to the batch processing script of database table, the core content of described script is that the bcp of sybase leads
Go out order；By performing described script, configuration timing plan target, carry out data syn-chronization.
The method of sybase storehouse intranet and extranet data syn-chronization based on VB exploitation the most according to claim 1, it is characterised in that
Described method operating procedure is as follows:
1) configuration connects intranet and extranet data source drive connection, it is judged that intranet and extranet database connectivity situation also writes log sheet；
2) read Intranet invoice table set, then judge whether outer net exists vocabulary, if it does not exist, then according to table name, field
Name outer net creates invoice table；
3) generate the derivation of data Intranet according to the bcp order of sybase storehouse, outer net imports autoexec；
4) the autoexec execution data importing that execution is generated is transferred.
The method of sybase storehouse intranet and extranet data syn-chronization based on VB exploitation the most according to claim 2, it is characterised in that
It is as follows that described method realizes flow process:
1) obtain intranet and extranet data base OBDC and connect source；
2) judge that intranet and extranet data base OBDC connects；
3) if the most all connected, misregistration daily record, flow process terminates；
4) if all connected, intranet data table name and outer net data table name are read；
5) judge that internal, external network data table name is the most consistent；
6) as inconsistent in internal, external network data table name, create the non-existent tables of data of outer net, generate derivation, import script；
7) as consistent in internal, external network data table name, then generate derivation, import script；
8) script generated is performed；
9) derivation data file is deleted；
10) flow process terminates.
The method of sybase storehouse intranet and extranet data syn-chronization based on VB exploitation the most according to claim 3, it is characterised in that:
Described flow process is program by VB exploitation.
The method of sybase storehouse intranet and extranet data syn-chronization based on VB exploitation the most according to claim 4, it is characterised in that:
Described program is timed scheduling by configuring plan target, it is achieved data automatic synchronization.
6. according to the method for the arbitrary described sybase storehouse intranet and extranet data syn-chronization based on VB exploitation of claim 3,4 or 5, its
It is characterised by: described method, by setting up and audit log table, checks that synchronization the most normally performs.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610396201.7A CN106095880A (en) | 2016-06-07 | 2016-06-07 | Method for synchronizing data of inner network and outer network of sybase based on VB development |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610396201.7A CN106095880A (en) | 2016-06-07 | 2016-06-07 | Method for synchronizing data of inner network and outer network of sybase based on VB development |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN106095880A true CN106095880A (en) | 2016-11-09 |
Family
ID=57448454
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201610396201.7A Pending CN106095880A (en) | 2016-06-07 | 2016-06-07 | Method for synchronizing data of inner network and outer network of sybase based on VB development |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN106095880A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112069255A (en) * | 2020-08-22 | 2020-12-11 | 苏州浪潮智能科技有限公司 | Method and device for synchronizing internal and external network database data |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102137132A (en) * | 2010-01-26 | 2011-07-27 | 腾讯科技（深圳）有限公司 | System and method for synchronizing data |
| CN102394927A (en) * | 2011-10-31 | 2012-03-28 | 国云科技股份有限公司 | Method for storing and synchronizing data of internal and external networks |
| US20130046787A1 (en) * | 2011-08-15 | 2013-02-21 | Justin Michael Ford | Methods and apparatus to interface an application to a database |
| CN103957172A (en) * | 2014-04-30 | 2014-07-30 | 无锡中科软信息技术有限公司 | Internal and external network physical isolation network data automatic switch |
| CN104778175A (en) * | 2014-01-13 | 2015-07-15 | 世纪禾光科技发展（北京）有限公司 | Method and system for realizing data synchronization of heterogeneous database |
| CN105005618A (en) * | 2015-07-21 | 2015-10-28 | 杭州合众数据技术有限公司 | Data synchronization method and system among heterogeneous databases |
-
2016
- 2016-06-07 CN CN201610396201.7A patent/CN106095880A/en active Pending
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102137132A (en) * | 2010-01-26 | 2011-07-27 | 腾讯科技（深圳）有限公司 | System and method for synchronizing data |
| US20130046787A1 (en) * | 2011-08-15 | 2013-02-21 | Justin Michael Ford | Methods and apparatus to interface an application to a database |
| CN102394927A (en) * | 2011-10-31 | 2012-03-28 | 国云科技股份有限公司 | Method for storing and synchronizing data of internal and external networks |
| CN104778175A (en) * | 2014-01-13 | 2015-07-15 | 世纪禾光科技发展（北京）有限公司 | Method and system for realizing data synchronization of heterogeneous database |
| CN103957172A (en) * | 2014-04-30 | 2014-07-30 | 无锡中科软信息技术有限公司 | Internal and external network physical isolation network data automatic switch |
| CN105005618A (en) * | 2015-07-21 | 2015-10-28 | 杭州合众数据技术有限公司 | Data synchronization method and system among heterogeneous databases |
Non-Patent Citations (1)
| Title |
|---|
| 宋兴彬: "基于BCP方法实现Sybase复制数据同步的研究", 《山东电子》 * |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112069255A (en) * | 2020-08-22 | 2020-12-11 | 苏州浪潮智能科技有限公司 | Method and device for synchronizing internal and external network database data |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN109885581B (en) | Database synchronization method, device, equipment and storage medium | |
| CN100541502C (en) | A kind of PCB analogue system and its implementation with error detection function | |
| CN104317843B (en) | A kind of data syn-chronization ETL system | |
| CN109977110A (en) | Data cleaning method, device and equipment | |
| CN107741903A (en) | Application compatibility method of testing, device, computer equipment and storage medium | |
| WO2015062181A1 (en) | Method for achieving automatic synchronization of multisource heterogeneous data resources | |
| CN103605663B (en) | General database checking and metadata loading method | |
| CN105205105A (en) | Data ETL (Extract Transform Load) system based on storm and treatment method based on storm | |
| CN107784026A (en) | A kind of ETL data processing methods and device | |
| CN106445618A (en) | Automatic database updating method | |
| CN109165124A (en) | A kind of embedded system hardware fault detection and processing method based on fault tree | |
| WO2018099179A1 (en) | Small function board recognition system and method | |
| CN107357259A (en) | A kind of chip mounter off-line programing information processing method | |
| CN102968349B (en) | Remote sensing image data file completeness method of calibration and system | |
| CN106919697A (en) | A kind of method that data are imported multiple Hadoop components simultaneously | |
| CN106126522A (en) | A kind of processing system of accounting statement | |
| CN106095880A (en) | Method for synchronizing data of inner network and outer network of sybase based on VB development | |
| CN104123376B (en) | A kind of intelligent text collecting method and system based on row template | |
| CN105701294B (en) | Realize the method and system of chip complex engineering modification | |
| CN105183971A (en) | PCB borehole enlargement method | |
| CN103895061A (en) | Method for machining holes in printed boards | |
| CN101393526A (en) | Data synchronization method capable of implementing programmable data conversion and file conversion function | |
| WO2018233121A1 (en) | Debugging tool configuration method, readable storage medium and debugging tool configuration device | |
| CN104461565B (en) | A kind of optical module test parameter collocation method and system | |
| CN101908985B (en) | A kind of method of message checking and device |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20161109 |
|
| RJ01 | Rejection of invention patent application after publication |