Teacher consult everybody: how to implement the kingdee financial software with pb script database *. Ais (it was encrypted access database), imported into the SQLSERVER2000 database? Without human through the following way:

Kingdee administrative career 6.2 version of the financial data backup there are two ways, one is financial software comes with backup data backup function, suffix called ". "AIB; The other is a direct copy background database, the suffix called ". AIS ", if you have the account set for many years, in the form of a suffix automatically become a "7", ". "AIB files, for example, in SQL server - African import template can be done through the following steps:

1. Correct understanding of background database, as a result of kingdee series is based on the ACCESS of backstage supporter's database, as a result, the backup file suffix ". The MDB "instead of explicit data source for" Microsoft ACCESS, "

2. The determination of the user name and password, as a result of kingdee database after a certain algorithm to encrypt, so using the data, the need to enter the user name and password, in the use of DTS, when the function is imported to input the user name into "Morningstar," password "ypbwkfyjhyhgzj
"
3. Driver Settings, ODB object "Jet OLEDB: System database" option of value is set to "System. The mda (user rights configuration file)", when setting the value, should indicate the path of the file System at the same time,

4. The backup data import to SQL server in advance to create the database,

Through the above four steps, the backup data can be turned into we can identify the data, find out the relevant credentials table, chart, and a current-account table, according to the data dictionary can sort out what we need to form,

CodePudding user response:

Access directly lead to essentially, convenient than made a script code,
But if you want to write a program to deal with their data, but can also,

CodePudding user response:

Attention!

CodePudding user response:

Not many people pay attention to?

CodePudding user response:

Know the ACCESS password, you can directly use data import/export tool to import SQL database.
PB6.5 connection ACCESS may have a problem.

CodePudding user response:

Data migration, all need to guide table columns,
Put in a configuration file,
Each table to build a data pipeline, from access to essentially,
Write a program cycle through the configuration file data pipeline

CodePudding user response:

This is the solution to PB program
If you can manual intervention,
Suggest directly use essentially DTS
Can also be preserved after the task allocation of each DTS arrange another time to use

CodePudding user response:

If a a processing, may be considered efficiency problem!

CodePudding user response:

The MIS is suitable

CodePudding user response:

The key is to use the program implementation, let the programmers also can easily to data import, hope everybody the teacher can speak more specific, such as a concrete example, thank you!

CodePudding user response:

The teacher can help to solve this problem, I am willing to pay, I do not know can 200 yuan?