CN107832465A - A kind of method for realizing data fast transferring - Google Patents
A kind of method for realizing data fast transferring Download PDFInfo
- Publication number
- CN107832465A CN107832465A CN201711217176.2A CN201711217176A CN107832465A CN 107832465 A CN107832465 A CN 107832465A CN 201711217176 A CN201711217176 A CN 201711217176A CN 107832465 A CN107832465 A CN 107832465A
- Authority
- CN
- China
- Prior art keywords
- data
- field
- excel
- target
- migration
- 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
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
-
- 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/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/284—Relational databases
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Computing Systems (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention provides a kind of method for realizing data fast transferring, this method is without the computing for needing progress complexity, also the Migration tools of complexity need not be used, only need to use conventional Microsoft Excel and common relevant database, to realize data asynchronous and caused data migration problems by cleverly operating, using data syn-chronization is simpler, cost is lower.
Description
Technical field
The invention belongs to the field of Data Migration, data processing and data syn-chronization, specifically one kind realizes that data are quickly moved
The method of shifting.
Background technology
Data are the Information bases that can not lack that we will face daily, Data Migration (also known as hierarchical storage management,
Hierarchical storage management, hsm) it is a kind of technology for merging offline storage with on-line storage.It will
At a high speed, next stage equipment of the non-Online storage device of high power capacity as disk unit, then presses the data commonly used in disk
The tactful Autonomic Migration Framework specified is to tape library（Abbreviation tape pool）Etc. on two level mass-memory unit.When needing to use these data
When, hierarchical stor automatically can adjust back to these data on upper level disk from next stage storage device.Come for user
To say, above-mentioned data migration operation is entirely transparent, is simply slightly neglected in the speed for accessing disk, and in logic magnetic disc
Substantially feel to substantially increase on capacity.
Data Migration is will to be rarely employed or no file moves on to the archive of secondary storage system (such as tape or CD)
Process.These files are typically need to be in the following image document or historical information that can enter accommodating access any time.Migrate work
Work is combined with backup policy, and still requires that schedule backup.Also include computer data to migrate, migrate old computer（Old system）In
Data, application program, personal settings wait until new computer（New system）, it is necessary after system upgrade.
The asynchronous synchronization after will necessarily producing Data Migration, and migration of data.
At present, our methods of common Data Migration are relative complex, and depend on some complex migration works
Tool, carry out the computing of complexity.
The content of the invention
In order to solve the above problems, the invention provides a kind of method for realizing data fast transferring, this method is without needs
Complicated computing is carried out, need not also use the Migration tools of complexity, it is only necessary to use conventional Microsoft Excel and common relation
Type database, to realize data asynchronous and caused data migration problems by cleverly operating, using data syn-chronization it is simpler,
Cost is lower.
The invention provides a kind of method for realizing data fast transferring, it comprises the following steps：
Step S10, Data Migration prepare：By the reading of relational database, it is ready to need the data migrated, and write
SQL statement or SQL statement section；
Step S20, data export：After getting out SQL statement or SQL statement section, by inquire about editing machine carry out it is executable
Inquiry is write, and exports as the file of EXCEL forms；
Step S30, field adjustment：Field quantity, field contents and field sequencing are adjusted according to actual conditions, meanwhile, will
Field determinant attribute carries out remarks；
Step S40, Data Migration：Adjusted and prepared according to step S30 field, contrast the field of the target Microsoft Excel of migration,
After confirmation, it would be desirable to the single-row duplication of derived data, then paste in field corresponding to target Microsoft Excel；So
After repeat single-row duplication, paste operation, until all needing the data paste List of field that migrates to target EXCEL tables
In lattice, then preserve, close EXCEL file；
Step S50, data import：The import feature carried by relational database, the EXCEL file that step S40 is obtained
It imported into target database, the name of tables of data is named according to actual conditions, then according to the What You See Is What You Get of database
Prompting is imported to complete to import step by step；
Step S60, data backup：The backup functionality carried using relational database is backed up, so far, this Data Migration
Operation has been fully completed.
Wherein, in the adjustment of described step S30 fields, when the Field Count in target table is more than the field in former tables of data
During number, default value setting is carried out according to the actual conditions of the field of target table, in data duplication, makes manually to enter
Row data are filled.
Wherein, in the adjustment of described step S30 fields, when the Field Count in target table is less than the field in former tables of data
During number, the field having more and its content included do not replicate directly；When the field of former table and the field name of object table
Differ and when information is consistent, directly replicate corresponding information under corresponding field.
Wherein, in described step S40 data migration operation, in addition to step S401 data processings, i.e., glued in data
After being attached to object table, before next field information duplication is not carried out, it would be desirable to which the modification of change " is looked into by what EXCEL was carried
Look for ", " all replace " functions carry out data processing.
Embodiment
A kind of method for realizing data fast transferring, it comprises the following steps：
Step S10, Data Migration prepare：By the reading of relational database, it is ready to need the data migrated, and write
SQL statement or SQL statement section；
Step S20, data export：After getting out SQL statement or SQL statement section, by inquire about editing machine carry out it is executable
Inquiry is write, and exports as the file of EXCEL forms；
Step S30, field adjustment：Field quantity, field contents and field sequencing are adjusted according to actual conditions, meanwhile, will
Field determinant attribute carries out remarks；
Step S40, Data Migration：Adjusted and prepared according to step S30 field, contrast the field of the target Microsoft Excel of migration,
After confirmation, it would be desirable to the single-row duplication of derived data, then paste in field corresponding to target Microsoft Excel；So
After repeat single-row duplication, paste operation, until all needing the data paste List of field that migrates to target EXCEL tables
In lattice, then preserve, close EXCEL file；
Step S50, data import：The import feature carried by relational database, the EXCEL file that step S40 is obtained
It imported into target database, the name of tables of data is named according to actual conditions, then according to the What You See Is What You Get of database
Prompting is imported to complete to import step by step；
Step S60, data backup：The backup functionality carried using relational database is backed up, so far, this Data Migration
Operation has been fully completed.
Wherein, in the adjustment of described step S30 fields, when the Field Count in target table is more than the field in former tables of data
During number, default value setting is carried out according to the actual conditions of the field of target table, in data duplication, makes manually to enter
Row data are filled.
Wherein, in the adjustment of described step S30 fields, when the Field Count in target table is less than the field in former tables of data
During number, the field having more and its content included do not replicate directly；When the field of former table and the field name of object table
Differ and when information is consistent, directly replicate corresponding information under corresponding field.
Wherein, in described step S40 data migration operation, in addition to step S401 data processings, i.e., glued in data
After being attached to object table, before next field information duplication is not carried out, it would be desirable to which the modification of change " is looked into by what EXCEL was carried
Look for ", " all replace " functions carry out data processing.
The above embodiments are intended merely to illustrate the purpose of the present invention and feature, not limit its protection domain.Therefore, its
He does not depart from the simplification carried out under Spirit Essence disclosed in this invention or principle, replacement or modification, completely should all include this hair
In bright covering scope.
Claims (4)
- A kind of 1. method for realizing data fast transferring, it is characterised in that it comprises the following steps：Step S10, Data Migration prepare：By the reading of relational database, it is ready to need the data migrated, and write SQL statement or SQL statement section；Step S20, data export：After getting out SQL statement or SQL statement section, by inquire about editing machine carry out it is executable Inquiry is write, and exports as the file of EXCEL forms；Step S30, field adjustment：Field quantity, field contents and field sequencing are adjusted according to actual conditions, meanwhile, will Field determinant attribute carries out remarks；Step S40, Data Migration：Adjusted and prepared according to step S30 field, contrast the field of the target Microsoft Excel of migration, After confirmation, it would be desirable to the single-row duplication of derived data, then paste in field corresponding to target Microsoft Excel；So After repeat single-row duplication, paste operation, until all needing the data paste List of field that migrates to target EXCEL tables In lattice, then preserve, close EXCEL file；Step S50, data import：The import feature carried by relational database, the EXCEL file that step S40 is obtained It imported into target database, the name of tables of data is named according to actual conditions, then according to the What You See Is What You Get of database Prompting is imported to complete to import step by step；Step S60, data backup：The backup functionality carried using relational database is backed up, so far, this Data Migration Operation has been fully completed.
- A kind of 2. method for realizing data fast transferring according to claim 1, it is characterised in that described step S30 In field adjustment, when the Field Count in target table is more than the Field Count in former tables of data, according to the field of target table Actual conditions carry out default value setting, in data duplication, make manually to carry out data filling.
- A kind of 3. method for realizing data fast transferring according to claim 1, it is characterised in that described step S30 In field adjustment, when the Field Count in target table is less than the Field Count in former tables of data, the field that has more and its included Content do not replicate directly；When the field of former table with the field name of object table differs and information is consistent when, it is directly multiple Corresponding information is made under corresponding field.
- A kind of 4. method for realizing data fast transferring according to claim 1, it is characterised in that described step S40 Data migration operation in, in addition to step S401 data processings that is, after data paste object table, are not carrying out next word Before segment information replicates, it would be desirable at " lookups " that the modification of change carries by EXCEL, " whole replacement " function progress data Reason.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201711217176.2A CN107832465A (en) | 2017-11-28 | 2017-11-28 | A kind of method for realizing data fast transferring |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201711217176.2A CN107832465A (en) | 2017-11-28 | 2017-11-28 | A kind of method for realizing data fast transferring |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN107832465A true CN107832465A (en) | 2018-03-23 |
Family
ID=61646033
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201711217176.2A Pending CN107832465A (en) | 2017-11-28 | 2017-11-28 | A kind of method for realizing data fast transferring |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN107832465A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108959205A (en) * | 2018-06-27 | 2018-12-07 | 成都泰盟软件有限公司 | A kind of method of ERP system export data fast transferring |
-
2017
- 2017-11-28 CN CN201711217176.2A patent/CN107832465A/en active Pending
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108959205A (en) * | 2018-06-27 | 2018-12-07 | 成都泰盟软件有限公司 | A kind of method of ERP system export data fast transferring |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN104850598B (en) | A kind of real-time data base back-up restoring method | |
| US20150254257A1 (en) | Seamless data migration across databases | |
| WO2018133578A1 (en) | Method and device for migrating virtual machine, computer storage medium, and electronic apparatus | |
| CN102541694A (en) | Method and device for database backup | |
| CN103064927A (en) | Data access method and device of distributed file system | |
| US10783040B2 (en) | Apparatus, system and method for data collection, import and modeling | |
| CN104376073A (en) | Database recovery method and device | |
| US20220121527A1 (en) | Dynamically updating database archive log dependency and backup copy recoverability | |
| EP2996025B1 (en) | Data migration tool with intermediate incremental copies | |
| CN109343863B (en) | Interface configuration method and system for HDFS (Hadoop distributed File System) permission | |
| CN107832465A (en) | A kind of method for realizing data fast transferring | |
| CN107844605A (en) | A kind of system of big data quick backup | |
| US11436089B2 (en) | Identifying database backup copy chaining | |
| US11966297B2 (en) | Identifying database archive log dependency and backup copy recoverability | |
| US8069148B2 (en) | Configuration of multiple database audits | |
| CN110019128A (en) | A kind of system of the synchronization MSSQL data of EXCEL application | |
| CN110019127A (en) | It is a kind of to fast implement the asynchronous information synchronization method of MYSQL database | |
| CN109254960B (en) | Method and device for migrating mass data of database | |
| CN107943971A (en) | A kind of AC system of the quick mutual photos and sending messages of internal user | |
| US10210224B2 (en) | Dynamic data copy utility | |
| US20050108226A1 (en) | Uniquely identifying an object before it is stored in a database | |
| US20240160759A1 (en) | Creator-protected copies in storage systems | |
| Corbett et al. | GOCDB-new communities, new requirements, new architecture | |
| CN101236519A (en) | Radioactive source control application level backup recovery method | |
| US10379960B1 (en) | Bypassing backup operations for specified database types |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| WD01 | Invention patent application deemed withdrawn after publication | ||
| WD01 | Invention patent application deemed withdrawn after publication |
Application publication date: 20180323 |