您的当前位置：首页正文

从远程数据库中导出视图.sql

来源：伴沃教育

$ exp sa/HISOFT@123 file=/dir/testaa.dmp log=testaa.log owner=

create view AAA as SELECT *

FROM OPENDATASOURCE('SQLNCLI', 'Data

Source=192.168.88.207;uid=AMSReader;pwd=AMSReader;').serp.dbo.AMS_Employee;

create view AMS_Employee as SELECT *

FROM OPENDATASOURCE( 'SQLNCLI','DATA

SOURCE=192.168.88.207;UID=AMSReader;pwd=AMSReader;').serp.dbo.AMS_Employee;

create view AMS_Project as SELECT *

FROM OPENDATASOURCE( 'SQLNCLI','DATA

SOURCE=192.168.88.207;UID=AMSReader;pwd=AMSReader;').serp.dbo.AMS_Project;

create view V_ProjectTechnology as SELECT *

FROM OPENDATASOURCE( 'SQLNCLI','DATA

SOURCE=192.168.88.207;UID=AMSReader;pwd=AMSReader;').serp.dbo.V_ProjectTechnology;

因篇幅问题不能全部显示，请点此查看更多更全内容

查看全文