![]() | CYQ.DBImport DataBase ToolAccess to Mssql,Mssql to MySql,MySql to Sqlite,Sqlite to oracle,oracle to access |
mssql 导入 oracle [教你如何将数据从mssql 导向 oracle]
mssql to other db |
|
|
| #TopicOwner |
如何将数据从:mssql 导入到oralce中呢? mssql和oracle,两个大牌子,一般只选一种,偶尔也会遇到要互转数据库的情况。 mssql 的数据导入导出好像自带了导入oracle的工具,只是没用过,不知道兼容性和会不会自动生成表架构信息,不知道生成的表架构信息又好不好呢,只是一堆疑问,这里就不介绍那个自带工具了,通常自带的工具大伙都用的有点纠心。 这里用:CYQ.DBImport来解决这个问题,使用简单的要命,生成的架构信息也很精准。 方式如下: 1:先下载工具:CYQ.DBImport 2:然后双击运行:CYQ.DBImport.exe 3:在DBConnection From中输入:mssql(2000/2005/2008)数据库的链接,点击“Connect” 4:在DBConnection To 中输入:oracle 数据库的链接,点击“Connect” 5:点击“(Un)Check”全选表,然后点击“Import Go”,即可完成数据库转换。 就这样轻松完成了。 mssql 相关的教程: Access相关的教程: ![]() |
Post Comment
Article Search
Categories
New Article
- Access to generate database design documents [to use CYQ.DBImport Tools]
- access to export table structure [to teach you how to get Access table structure script]
- import access into oracle [teach you how to move data from Access to oracle]
- import access into sqlite [teach you how to move data from Access to sqlite]
- import access into mysql [teach you how to move data from Access to mysql]
- import access into mssql(2000/2005/2008)[teach you how to move data from Access to mssql(2000/2005/2008)]
- CYQ.DBImport V2.0 [Support database reverse engineering/import data/Export of various databases of professional database design document ]
- CYQ.DBImport V1.0 [support database reverse engineering,import data from one database into another database]
New Comment
- xo5OrQqk'); waitfor delay '0:0:15' --
- 1 waitfor delay '0:0:15' --
- 1\0����%2527%2522
- 555*DBMS_PIPE.RECEIVE_MESSAGE(CHR(99)||CHR(99)||CHR(99),15)
- SghhtkbH' OR 608=(SELECT 608 FROM PG_SLEEP(15))--
- -5) OR 675=(SELECT 675 FROM PG_SLEEP(15))--
- -1' OR 3+189-189-1=0+0+0+1 or 'FKg61Tbo'='
- -1 OR 3+812-812-1=0+0+0+1
- fCaFTdWp')); waitfor delay '0:0:15' --
- M0QrJsuS'; waitfor delay '0:0:15' --