[架构]201223-国产达梦数据库DM8

服务器地址: 192.168.100.100端口：22用户名：root密码：******

服务器配置

测试脚本：select * from test;

1. cd /opt/dmdbms/bin2. 执行./disql SYSDBA/SYSDBA@localhost

默认帐号密码: SYSDBA默认端口:5236

登录数据库

dminit

./dmfldr userid=SYSDBA/SYSDBA@localhost:5236 control=\\'/opt/data/test.ctl\\' null_mode=true

dmfldr

./disql SYSDBA/SYSDBA `D:\\test.sql

disql

GB18030

数据导入

引号，单引号，双引号

注意事项

jdbcDriver:  dm.jdbc.driver.DmDriverurl:  jdbc:dm://localhost:5236userName:  SYSDBApassword:  SYSDBA

config

DmJdbcDriver16 .jar - JDK16

DmJdbcDriver17 .jar - JDK17

DmJdbcDriver18 .jar - JDK18

\\dmdbms\\jdbc\\

jar

JDBC

#CREATE TABLESPACE TS_DATA DATAFILE 'TS_DATA01.DBF' SIZE 2048;ALTER TABLESPACE TS__DATA ADD DATAFILE 'TS_DATA02.DBF' size 2048;#CREATE TABLESPACE TS_IDX DATAFILE 'TS_IDX01.DBF' SIZE 1024;ALTER TABLESPACE TS_IDX ADD DATAFILE 'TS_IDX02.DBF' SIZE 1024;# CREATE USER TEST_USER IDENTIFIED BY TEST_PASSWORD DISKSPACE LIMIT 50;CREATE USER TESTDB IDENTIFIED BY \"TESTDB\" DISKSPACE UNLIMITED DEFAULT TABLESPACE TS_DATA DEFAULT INDEX TABLESPACE TS_IDX;#GRANT RESOURCE TO TESTDB;

创建数据库

DTS (Tool)

数据迁移

开发对接

DM8