将数据从orace导入sql sever 2008方法.doc
文本预览下载声明
oracle数据导入sql server 2008方法
随着社会的发展,各被审计单位的数据量也不断增加。过去常用的小型数据库已经不能适应时代的发展,大型数据库逐渐普遍起来,尤其已oracle数据为代表的大型数据库更是被众多单位、公司和企业采用,因此掌握oracle数据库的备份与还原显得尤为重要。
以下阐述的是将oracle数据导入sql server 2008的步骤。
第一步:配置数据源
开始→控制面板→管理工具→数据源(ODBC)
选择“系统DNS”,单击“添加”按钮
选择“oracle in oradb11g_home1”驱动程序,点击“完成”
data source name填用户自填的数据源名称,TNS service name 填oracle数据库中所要导入数据的实例名,user id填该实例名授权的用户名,点击test connection
password填与上述实例用户的密码,填写后单击“ok”
点击“确定”,表示数据源配置成功
第二步:用sql server 2008连接oracle数据库
开始→所有程序→microsoft sql server 2008 r2→sql server management studio
连接后,新建数据库→右击该数据库→任务→导入数据
数据源选择“oracle provider for ole db” →属性
数据源、用户名和密码均与第一步中的相同。然后选择“允许保存密码”否则将无法进行到下一步。
目标选择:sql server native client 10.0,其他均选择默认值→下一步
下一步
选择所需要的表和视图(可多选),点击“下一步”
通过上述步骤,可以将oracle数据导入sql server 2008中。
reform results, economy, and political system, and culture system, and social system, and discipline check system, and party of construction system reform solid advance, tax, and financial, and price, and administrative approval, and State-owned enterprises, and ecological civilization, important field and key link reform made major progress, market in resources configuration in the of decisive role significantly enhanced, Unprecedented burst of momentum and vitality of economic and social development. XI General Secretarys speech in this regard include the reform only when there is no complete, the decisions of the CPC Central Committee on some major problems in deepening reform notes on the 18 session of ideas into the partys spirit of the reforms more difficult to move forward, the increasing use of the Socialist system with Chinese characteristics such as the ability to run the country. 4. with regard to promoting sustained and healthy economic development. Face complex changeable of international situation and difficult heavy of domestic reform development stable task, XI General Secretary made China economic development into new normal of science judge, proposed innovation, and coordination, and g
显示全部