不允许使用迁移技术,因为我们希望复制数据,而不是移动或传输数据。数据访问:从Oracle 10g只读。Visual Studio 2013。2012年SSMS。我几乎尝试了网络上所有可能的程序。这个是SQLBULKCopy。
public partial class defaultScribd: System.Web.UI.Page
{
public void Page_Load(object sender, EventArgs e) {
}
public void Button1_Click(Object Sender, EventArgs e)
{
string sourcecs = ConfigurationManager.ConnectionStrings["SourceCS"].ConnectionString;
string destinationCS = ConfigurationManager.ConnectionStrings["DestinationCS"].ConnectionString;
using(SqlConnection sourcecon = new SqlConnection(sourcecs)) {
SqlCommand cmd = new SqlCommand("Select * from mfa", sourcecon);
sourcecon.Open();
using(SqlDataReader rdr = cmd.ExecuteReader()) {
using(SqlConnection destinationcon = new SqlConnection(destinationCS)) {
using(SqlBulkCopy bc = new SqlBulkCopy(destinationcon)) {
bc.DestinationTableName = "shub1";
destinationcon.Open();
bc.WriteToServer(rdr);
}
}
}
}
}
}