测试环境下模拟真实数据库数据移植

最新推荐文章于 2021-06-19 17:22:50 发布
最新推荐文章于 2021-06-19 17:22:50 发布
阅读量167 收藏
点赞数
文章标签： 数据库
原文链接：http://www.cnblogs.com/arcer/p/3180411.html
版权

实验目的：实验数据库数据移植

实验环境：

　　源数据库:两个节点的RAC数据库，数据库版本11203

　　目标数据库：单实例数据库，版本11203

要求：源数据库schema所在表空间为USERS,移植到目标数据库后调整为新表空间APP_FGPS

1、实验准备　　

1.1、倒出数据库

[oracle@rac1 mydump]$ expdp ARCER/ARCER dumpfile=fgps.dmp directory=dmp_dir logfile=fgps.log 

Export: Release 11.2.0.1.0 - Production on Tue Jul 9 15:31:31 2013

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
Starting "ARCER"."SYS_EXPORT_SCHEMA_01":  ARCER/******** dumpfile=fgps.dmp directory=dmp_dir logfile=fgps.log 
Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 3.5 MB
Processing object type SCHEMA_EXPORT/USER
Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
Processing object type SCHEMA_EXPORT/ROLE_GRANT
Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/SEQUENCE/SEQUENCE
Processing object type SCHEMA_EXPORT/TABLE/TABLE
Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type SCHEMA_EXPORT/TABLE/COMMENT
Processing object type SCHEMA_EXPORT/PACKAGE/PACKAGE_SPEC
Processing object type SCHEMA_EXPORT/FUNCTION/FUNCTION
Processing object type SCHEMA_EXPORT/PROCEDURE/PROCEDURE
Processing object type SCHEMA_EXPORT/PACKAGE/COMPILE_PACKAGE/PACKAGE_SPEC/ALTER_PACKAGE_SPEC
Processing object type SCHEMA_EXPORT/FUNCTION/ALTER_FUNCTION
Processing object type SCHEMA_EXPORT/PROCEDURE/ALTER_PROCEDURE
Processing object type SCHEMA_EXPORT/VIEW/VIEW
Processing object type SCHEMA_EXPORT/PACKAGE/PACKAGE_BODY
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/TRIGGER
Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Processing object type SCHEMA_EXPORT/POST_SCHEMA/PROCOBJ
. . exported "ARCER"."FRX_OA_WORKLOG"                    43.15 KB      89 rows
. . exported "ARCER"."FRX_OA_ATTENDANCE"                 353.5 KB    4486 rows
. . exported "ARCER"."NETSTORE"                          66.53 KB     243 rows
. . exported "ARCER"."NETSTORE_INCOMEEXPENDITURELIST"     71.5 KB     266 rows
. . exported "ARCER"."COILS_ASSETS_DEPRECIATION"         19.81 KB      55 rows
. . exported "ARCER"."COILS_CODE_ASSESS"                 12.84 KB      38 rows
. . exported "ARCER"."COILS_COMPANY_LICENSE"             13.57 KB      16 rows
. . exported "ARCER"."COILS_EMP"                         6.023 KB       8 rows
. . exported "ARCER"."COILS_LOG_ASSESS"                  11.32 KB      14 rows
. . exported "ARCER"."COILS_STORES"                      13.66 KB      37 rows
. . exported "ARCER"."COMPANY_ANNOUNCEMENT"              11.86 KB       3 rows
. . exported "ARCER"."CRM_CUSTOMER"                      23.26 KB      52 rows
. . exported "ARCER"."FGPS_EMPLOYEE"                     11.57 KB      35 rows
. . exported "ARCER"."FGPS_FINANCEUNIT"                  7.218 KB       3 rows
. . exported "ARCER"."FGPS_GROUP"                        8.914 KB      20 rows
. . exported "ARCER"."FGPS_GROUP_VS_MENU"                7.632 KB     212 rows
. . exported "ARCER"."FGPS_MENU"                         11.56 KB      51 rows
. . exported "ARCER"."FGPS_MYRECEIVER"                   14.09 KB      40 rows
. . exported "ARCER"."FGPS_PEOPLE"                       34.10 KB     800 rows
. . exported "ARCER"."FGPS_SYSTEMUSER"                   10.39 KB       7 rows
. . exported "ARCER"."FGPS_USER"                         14.90 KB      36 rows
. . exported "ARCER"."FGPS_USERGRANTACCOUNT"             11.34 KB      30 rows
. . exported "ARCER"."FGPS_VOUCHER"                      29.18 KB      68 rows
. . exported "ARCER"."FRX_DEV_SUGGEST"                   10.23 KB      26 rows
. . exported "ARCER"."FRX_OA_DICT"                       40.74 KB     486 rows
. . exported "ARCER"."FRX_OA_LOG_TEMPLATE"               10.60 KB      26 rows
. . exported "ARCER"."INVESTMENT_INCOME_STATEMENT"       19.35 KB      57 rows
. . exported "ARCER"."SYSTEM_GROUP"                      9.265 KB      35 rows
. . exported "ARCER"."SYSTEM_MENU"                       8.617 KB      34 rows
. . exported "ARCER"."SYS_CATEGORY"                      9.234 KB      33 rows
. . exported "ARCER"."SYS_GROUP_MENU_CORRESPONDENCE"     6.429 KB     100 rows
. . exported "ARCER"."WAITTINGHANDLER"                   19.37 KB      88 rows
. . exported "ARCER"."WAITTING_HANDLER_DETAIL"           13.33 KB     100 rows
Master table "ARCER"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded
******************************************************************************
Dump file set for ARCER.SYS_EXPORT_SCHEMA_01 is:
  /home/oracle/mydump/fgps.dmp
Job "ARCER"."SYS_EXPORT_SCHEMA_01" successfully completed at 15:32:28

[oracle@rac1 mydump]$ ll
total 2360
-rw-r----- 1 oracle asmadmin  172032 Jul  9 15:17 arcer.dmp
-rw-r--r-- 1 oracle asmadmin    1394 Jul  9 15:17 arcer.log
-rw-r----- 1 oracle asmadmin 2224128 Jul  9 15:32 fgps.dmp
-rw-r--r-- 1 oracle asmadmin    4884 Jul  9 15:32 fgps.log
倒出源数据库schema->ARCER

1.2、ftp上传到目标数据库服务器

2、创建目录对象的物理目录/home/oracle/dmp_dir、表空间app_fgps

11203ora-> id
uid=1101(oracle) gid=1000(oinstall) groups=1000(oinstall),1300(dba),1301(oper)
11203ora-> ll
total 4
drwxr-xr-x 8 oracle oinstall 4096 Sep 22  2011 database
11203ora-> pwd
/home/oracle
11203ora-> mkdir mydmp
11203ora-> ll
total 8
drwxr-xr-x 8 oracle oinstall 4096 Sep 22  2011 database
drwxr-xr-x 2 oracle oinstall 4096 Jul 10 00:08 mydmp
11203ora-> cd mydmp/
11203ora-> ll
total 0
11203ora-> pwd
/home/oracle/mydmp
11203ora->
View Code 
11203ora-> id
uid=1101(oracle) gid=1000(oinstall) groups=1000(oinstall),1300(dba),1301(oper)
11203ora-> sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Wed Jul 10 00:09:54 2013

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> 
SQL> CREATE TABLESPACE APP_FGPS DATAFILE  '/u01/app/oracle/oradata/testdb/DATACENTER01.dbf' SIZE 200M AUTOEXTEND ON NEXT 50M MAXSIZE 500M;

Tablespace created.
SQL> col name for a60
SQL> set linesize 200
SQL> select name,status from v$datafile;

NAME                                                         STATUS
------------------------------------------------------------ -------
/u01/app/oracle/oradata/testdb/system01.dbf                  SYSTEM
/u01/app/oracle/oradata/testdb/sysaux01.dbf                  ONLINE
/u01/app/oracle/oradata/testdb/undotbs01.dbf                 ONLINE
/u01/app/oracle/oradata/testdb/users01.dbf                   ONLINE
/u01/app/oracle/oradata/testdb/example01.dbf                 ONLINE
/u01/app/oracle/oradata/testdb/DATACENTER01.dbf              ONLINE

6 rows selected.
SQL> col file_name for a60
SQL> select file_name,tablespace_name from dba_data_files;

FILE_NAME                                                    TABLESPACE_NAME
------------------------------------------------------------ ------------------------------
/u01/app/oracle/oradata/testdb/users01.dbf                   USERS
/u01/app/oracle/oradata/testdb/undotbs01.dbf                 UNDOTBS1
/u01/app/oracle/oradata/testdb/sysaux01.dbf                  SYSAUX
/u01/app/oracle/oradata/testdb/system01.dbf                  SYSTEM
/u01/app/oracle/oradata/testdb/example01.dbf                 EXAMPLE
/u01/app/oracle/oradata/testdb/DATACENTER01.dbf              APP_FGPS

6 rows selected.

SQL>
创建表空间

 

 3、创建用户ARCER、用户授权、创建该用户下的目录对象

SQL> create user ARCER identified by ARCER default tablespace app_fgps;

User created.

SQL> grant connect,dba,resource to ARCER;

Grant succeeded.

SQL> conn ARCER/ARCER
Connected.
SQL> create directory dmp_dir as '/home/oracle/mydmp/';

Directory created.

SQL> select * from tab;

no rows selected

SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
View Code

4、执行导入操作

11203ora-> ll
total 2180
-rw-r--r-- 1 oracle oinstall 2224128 Jul  9 15:32 fgps.dmp
-rw-r--r-- 1 oracle oinstall    5882 Jul  9 15:59 fgps.log
11203ora-> pwd
/home/oracle/mydmp
11203ora-> impdp ARCER/ARCER dumpfile=fgps.dmp directory=dmp_dir logfile=fgps.log remap_schema=ARCER:ARCER remap_tablespace=users:app_fgps

Import: Release 11.2.0.3.0 - Production on Wed Jul 10 00:14:47 2013

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Master table "ARCER"."SYS_IMPORT_FULL_01" successfully loaded/unloaded
Starting "ARCER"."SYS_IMPORT_FULL_01":  ARCER/******** dumpfile=fgps.dmp directory=dmp_dir logfile=fgps.log remap_schema=ARCER:ARCER remap_tablespace=users:app_fgps 
Processing object type SCHEMA_EXPORT/USER
ORA-31684: Object type USER:"ARCER" already exists
Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
Processing object type SCHEMA_EXPORT/ROLE_GRANT
Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/SEQUENCE/SEQUENCE
Processing object type SCHEMA_EXPORT/TABLE/TABLE
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
. . imported "ARCER"."FRX_OA_WORKLOG"                    43.15 KB      89 rows
. . imported "ARCER"."FRX_OA_ATTENDANCE"                 353.5 KB    4486 rows
. . imported "ARCER"."NETSTORE"                          66.53 KB     243 rows
. . imported "ARCER"."NETSTORE_INCOMEEXPENDITURELIST"     71.5 KB     266 rows
. . imported "ARCER"."COILS_ASSETS_DEPRECIATION"         19.81 KB      55 rows
. . imported "ARCER"."COILS_CODE_ASSESS"                 12.84 KB      38 rows
. . imported "ARCER"."COILS_COMPANY_LICENSE"             13.57 KB      16 rows
. . imported "ARCER"."COILS_EMP"                         6.023 KB       8 rows
. . imported "ARCER"."COILS_LOG_ASSESS"                  11.32 KB      14 rows
. . imported "ARCER"."COILS_STORES"                      13.66 KB      37 rows
. . imported "ARCER"."COMPANY_ANNOUNCEMENT"              11.86 KB       3 rows
. . imported "ARCER"."CRM_CUSTOMER"                      23.26 KB      52 rows
. . imported "ARCER"."FGPS_EMPLOYEE"                     11.57 KB      35 rows
. . imported "ARCER"."FGPS_FINANCEUNIT"                  7.218 KB       3 rows
. . imported "ARCER"."FGPS_GROUP"                        8.914 KB      20 rows
. . imported "ARCER"."FGPS_GROUP_VS_MENU"                7.632 KB     212 rows
. . imported "ARCER"."FGPS_MENU"                         11.56 KB      51 rows
. . imported "ARCER"."FGPS_MYRECEIVER"                   14.09 KB      40 rows
. . imported "ARCER"."FGPS_PEOPLE"                       34.10 KB     800 rows
. . imported "ARCER"."FGPS_SYSTEMUSER"                   10.39 KB       7 rows
. . imported "ARCER"."FGPS_USER"                         14.90 KB      36 rows
. . imported "ARCER"."FGPS_USERGRANTACCOUNT"             11.34 KB      30 rows
. . imported "ARCER"."FGPS_VOUCHER"                      29.18 KB      68 rows
. . imported "ARCER"."FRX_DEV_SUGGEST"                   10.23 KB      26 rows
. . imported "ARCER"."FRX_OA_DICT"                       40.74 KB     486 rows
. . imported "ARCER"."FRX_OA_LOG_TEMPLATE"               10.60 KB      26 rows
. . imported "ARCER"."INVESTMENT_INCOME_STATEMENT"       19.35 KB      57 rows
. . imported "ARCER"."SYSTEM_GROUP"                      9.265 KB      35 rows
. . imported "ARCER"."SYSTEM_MENU"                       8.617 KB      34 rows
. . imported "ARCER"."SYS_CATEGORY"                      9.234 KB      33 rows
. . imported "ARCER"."SYS_GROUP_MENU_CORRESPONDENCE"     6.429 KB     100 rows
. . imported "ARCER"."WAITTINGHANDLER"                   19.37 KB      88 rows
. . imported "ARCER"."WAITTING_HANDLER_DETAIL"           13.33 KB     100 rows
Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type SCHEMA_EXPORT/TABLE/COMMENT
Processing object type SCHEMA_EXPORT/PACKAGE/PACKAGE_SPEC
Processing object type SCHEMA_EXPORT/FUNCTION/FUNCTION
Processing object type SCHEMA_EXPORT/PROCEDURE/PROCEDURE
Processing object type SCHEMA_EXPORT/PACKAGE/COMPILE_PACKAGE/PACKAGE_SPEC/ALTER_PACKAGE_SPEC
Processing object type SCHEMA_EXPORT/FUNCTION/ALTER_FUNCTION
Processing object type SCHEMA_EXPORT/PROCEDURE/ALTER_PROCEDURE
Processing object type SCHEMA_EXPORT/VIEW/VIEW
Processing object type SCHEMA_EXPORT/PACKAGE/PACKAGE_BODY
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/TRIGGER
Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Processing object type SCHEMA_EXPORT/POST_SCHEMA/PROCOBJ
Job "ARCER"."SYS_IMPORT_FULL_01" completed with 1 error(s) at 00:15:18

11203ora->
View Code

 

5、验证数据

11203ora-> sqlplus ARCER/ARCER

SQL*Plus: Release 11.2.0.3.0 Production on Wed Jul 10 00:16:15 2013

Copyright (c) 1982, 2011, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select * from tab;

TNAME                          TABTYPE  CLUSTERID
------------------------------ ------- ----------
COILS_ASSETS_DEPRECIATION      TABLE
COILS_CODE_ASSESS              TABLE
COILS_COMPANY_LICENSE          TABLE
COILS_EMP                      TABLE
COILS_LOG_ASSESS               TABLE
COILS_STORES                   TABLE
COMPANY_ANNOUNCEMENT           TABLE
CRM_CUSTOMER                   TABLE
FGPS_EMPLOYEE                  TABLE
FGPS_FINANCEUNIT               TABLE
FGPS_GROUP                     TABLE

TNAME                          TABTYPE  CLUSTERID
------------------------------ ------- ----------
FGPS_GROUP_VS_MENU             TABLE
FGPS_MENU                      TABLE
FGPS_MYRECEIVER                TABLE
FGPS_PEOPLE                    TABLE
FGPS_SYSTEMUSER                TABLE
FGPS_USER                      TABLE
FGPS_USERGRANTACCOUNT          TABLE
FGPS_VOUCHER                   TABLE
FRX_DEV_SUGGEST                TABLE
FRX_OA_ATTENDANCE              TABLE
FRX_OA_DICT                    TABLE

TNAME                          TABTYPE  CLUSTERID
------------------------------ ------- ----------
FRX_OA_LOG_TEMPLATE            TABLE
FRX_OA_WORKLOG                 TABLE
INVESTMENT_INCOME_STATEMENT    TABLE
NETSTORE                       TABLE
NETSTORE_INCOMEEXPENDITURELIST TABLE
RECHARGE_SUM_VW                VIEW
SYSTEM_GROUP                   TABLE
SYSTEM_MENU                    TABLE
SYS_CATEGORY                   TABLE
SYS_GROUP_MENU_CORRESPONDENCE  TABLE
WAITTINGHANDLER                TABLE

TNAME                          TABTYPE  CLUSTERID
------------------------------ ------- ----------
WAITTING_HANDLER_DETAIL        TABLE

34 rows selected.

SQL> col segment_name al 30
SP2-0158: unknown COLUMN option "al"
SQL> col segment_name a30
SP2-0158: unknown COLUMN option "a30"
SQL> col segment_name  for a30
SQL> select segment_name,tablespace_name from user_segments;

SEGMENT_NAME                   TABLESPACE_NAME
------------------------------ ------------------------------
CATEGORY_PK_CID                APP_FGPS
CATEGORY_UC_KEY                APP_FGPS
CL_ID_PK                       APP_FGPS
CL_NAME_UK                     APP_FGPS
COILS_ASSETS_DEPRECIATION      APP_FGPS
COILS_CODE_ASSESS              APP_FGPS
COILS_COMPANY_LICENSE          APP_FGPS
COILS_EMP                      APP_FGPS
COILS_LOG_ASSESS               APP_FGPS
COILS_STORES                   APP_FGPS
COMPANY_ANNOUNCEMENT           APP_FGPS

SEGMENT_NAME                   TABLESPACE_NAME
------------------------------ ------------------------------
CRM_CID_PK                     APP_FGPS
CRM_CUSTOMER                   APP_FGPS
DICT_ID                        APP_FGPS
FGPS_EMPLOYEE                  APP_FGPS
FGPS_FINANCEUNIT               APP_FGPS
FGPS_GROUP                     APP_FGPS
FGPS_GROUP_VS_MENU             APP_FGPS
FGPS_MENU                      APP_FGPS
FGPS_MYRECEIVER                APP_FGPS
FGPS_PEOPLE                    APP_FGPS
FGPS_SYSTEMUSER                APP_FGPS

SEGMENT_NAME                   TABLESPACE_NAME
------------------------------ ------------------------------
FGPS_USER                      APP_FGPS
FGPS_USERGRANTACCOUNT          APP_FGPS
FGPS_VOUCHER                   APP_FGPS
FRX_DEV_SUGGEST                APP_FGPS
FRX_OA_ATTENDANCE              APP_FGPS
FRX_OA_DICT                    APP_FGPS
FRX_OA_LOG_TEMPLATE            APP_FGPS
FRX_OA_WORKLOG                 APP_FGPS
ID_PK                          APP_FGPS
INVESTMENT_INCOME_STATEMENT    APP_FGPS
NETSTORE                       APP_FGPS

SEGMENT_NAME                   TABLESPACE_NAME
------------------------------ ------------------------------
NETSTORE_INCOMEEXPENDITURELIST APP_FGPS
PK_ATTENDANCE_ID               APP_FGPS
PK_CID                         APP_FGPS
PK_EID                         APP_FGPS
PK_FGPS_FINANCEUNIT            APP_FGPS
PK_FGPS_GROUPID                APP_FGPS
PK_FGPS_MENUID                 APP_FGPS
PK_FGPS_SYSTEMUSER             APP_FGPS
PK_FGPS_USERGRANTACCOUNT       APP_FGPS
PK_FGPS_USERID                 APP_FGPS
PK_FGPS_VOUCHER                APP_FGPS

SEGMENT_NAME                   TABLESPACE_NAME
------------------------------ ------------------------------
PK_GROUPID                     APP_FGPS
PK_ID                          APP_FGPS
PK_ID_FRX_DEV_SUGGEST          APP_FGPS
PK_LID                         APP_FGPS
PK_LOG_CATEGORY_TEMPLATE_ID    APP_FGPS
PK_MENUID                      APP_FGPS
PK_NETSTORE_INCOMEEXPENDITUREL APP_FGPS
PK_SYS_ASSET_NO                APP_FGPS
STORE_ID_PK                    APP_FGPS
SYSTEM_GROUP                   APP_FGPS
SYSTEM_MENU                    APP_FGPS

SEGMENT_NAME                   TABLESPACE_NAME
------------------------------ ------------------------------
SYS_C0011356                   APP_FGPS
SYS_C0011372                   APP_FGPS
SYS_C0011378                   APP_FGPS
SYS_C0011379                   APP_FGPS
SYS_CATEGORY                   APP_FGPS
SYS_GROUP_MENU_CORRESPONDENCE  APP_FGPS
WAITTINGHANDLER                APP_FGPS
WAITTING_HANDLER_DETAIL        APP_FGPS
WORKLOG_PK_WID                 APP_FGPS

64 rows selected.

SQL>
View Code

 

 

转载于:https://www.cnblogs.com/arcer/p/3180411.html

weixin_30448685
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
mock:Aimee框架的mock模块，用于支持测试环境数据模拟
04-27
Mock Aimee框架的mock模块，用于支持模拟数据
SpringBoot模拟数据库开发
qq_43730903的博客
02-02 947
SpringBoot模拟数据库开发
轻松模拟数据库
danpu0978的博客
04-17 1010
测试驱动的开发真是太好了！ 在组织中建立它之后，您将开始： 极大地提高您的质量（事情不常发生） 大大改善您的流程（事情可以更轻松地更改） 极大地改善您的开发人员氛围（事情更有趣） 进行正确的测试驱动开发的重要性是找到要覆盖的代码的良好比例。 通过自动单元测试 通过自动集成测试 通过手动“烟雾测试” 通过手动的“验收测试” 一点也不 找到该比例可...
模拟数据库
11-29
数据库
软件测试工具TestDirector8.0项目数据库维护和移植
03-23
testdirectorTestDirector软件测试工具TestDirector8.0项目数据库维护和移植1.TD项目的备份与还原备份TD的重要信息，以在TD系统出现灾难性故障后能够保全TD数据的安全和完整，并且为快速的恢复系统和数据提供保障。...
SQL Server和国产数据库之间数据移植研究.pdf
09-19
SQL Server和国产数据库之间数据移植研究.pdf
数据库的移植操作
12-14
在必要情况下我们必须对目标数据库进行合法的移植操作 关闭MSSQLSERVER服务的方式 如果直接关闭服务(相当于直接关闭服务器)，会对正在运行的项目造成威胁 推荐使用以下方式： 注意：在数据库移植之前必须要明确目标...
数据移植、导出、数据库文档生成工具
01-07
强大的sql server数据库处理工具；支持数据库移植技术，不同数据库数据交互；可直接从数据库生成数据库字典文档等强大功能
异构环境下Oracle数据移植问题研究.pdf
10-10
异构环境下Oracle数据移植问题研究.pdf
对口升学VF数据库模拟试卷一（含答案）
09-23
本文档为中职对口升学计算机专业所学课程数据库VF的模拟测试卷，里面包含答案。本人在数据库VF教学这块有多年经验，这套试卷分为章节练习和模拟测试卷。
三级数据库模拟软件
08-03
计算机等级考试三级数据库技术模拟软件
2020-08-31
weixin_48100502的博客
08-31 121
模拟数据库 public class DepartmentDao{ private static Map<Integer,Department> departments = null; static{ departments = new HashMap<Integer,Department>(); departments.put(101,new Department(101,"教学部")); departments.put(101,new Department
模拟数据库系统
飘的梦客厅
04-04 1586
本文是介绍了一个用汇编实现的简易的学生档案管理系统.学生的属性有学号、姓名、性别、生日、地址、英语成绩、语文成绩、数学成绩和总成绩.四个成绩的精度到小数点后两位.系统的的运行过程是:开始一个登陆界面,需要输入密码(8位),当输入完8位,并且正确时,自动进入系统.首先看到的是一个菜单,菜单显示了改系统提供的所有操作,这些操作的选择使用上下键来操作,当选择一个选项时,再使用回车键去确认即可执行改操作.
DI v6.2，从测试环境移植到生产环境，如何清理以前运行过的垃圾数据（作业监控记录等信息及后台日志记录相关数据）
普元开发者乐园
04-05 791
问题描述：DI Manager从测试环境中的参数等配置及开发作业及作业流的全部数据完整迁移至生产环境，如何将测试环境原先的垃圾数据删除（作业监控记录等信息及后台日志记录相关信息或其它无用的数据文件）解决办法： 执行相关数据库表的 delete 操作，具体如下： delete FROM TSC_JOBFLOWLOG; delete FROM TSC_JOBFLOWLOGHIS; delete
模拟数据库ORM
YunSu_CJ的博客
11-25 311
一、什么是ORM？ ORM 就是通过实例对象的语法，完成关系型数据库的操作的技术，是"对象-关系映射"（Object/Relational Mapping） 的缩写。ORM 把数据库表映射成对象。 二、为什么需要ORM ORM 使用对象，封装了数据库操作，因此可以不碰 SQL 语言。开发者只使用面向对象编程，与数据对象直接交互，不用关心底层数据库。在实际编程中，需要大量编写重复sql语句，为了提高程序员的开发效率，开发ORM工具。使用ORM工具程序员只需要构建映射关系，就可以实现对数据库表的创建、查询、修改
模拟数据库操作
王某人的博客
08-27 3117
思考第一个问题：为什么模拟数据库操作时，要使用Map而不是List 例如：findById操作，如果是List，只能遍历 如果是Map<key,value>， 根据key读取value，效率高 下面利用了SpringMVC的迷你框架
模拟数据库的操作
有时间可以指导毕业设计，可以私聊我。一个热爱编程的smallCuteMonkey，可以私信我
06-19 274
//模拟数据库中的数据 private static Map<Integer, Employee> employeeMap=null; // 员工有所属的部门 @Autowired private DepartmentDao departmentDao; static { // 创建一个部门表 employeeMap=new HashMap<Integer, Employee>(); ...
linux环境下移植mqtt到qt上面
最新发布
05-24
以下是在Linux环境下将Paho MQTT移植到Qt的一些步骤： 1. 安装Paho MQTT库 您可以从Paho MQTT的官方网站下载Paho MQTT库的源代码，并按照说明进行安装。 2. 创建Qt项目 在Qt Creator中创建一个新的Qt控制台应用...

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值