這樣所有的賬戶都改為dbo，即可。

下一步，把腳本命名為sqlscript.txt， 最好不要叫sqlscript.sql，下面會(huì)介紹。

然后通過(guò)ftp把腳本放到網(wǎng)站的空間。

編寫腳本，例如命名為runsql.aspx ，然后運(yùn)行該腳本即可還原數(shù)據(jù)庫(kù)

<%

// Sample code for executing a T-SQL file using an ASP.NET page

// Copyright (C) Microsoft Corporation, 2007. All rights reserved.

// Written as a sample with use in conjuction with the SQL Server Database Publishing Wizard

// For more information visit http://www.codeplex.com/sqlhost/

// **************************************************************************

// Note: Please ensure that you delete this page once your database has been published to the remote server

// **************************************************************************

%>

<%@ Page Language="C#" AutoEventWireup="true" %>

<%@ Import Namespace="System.Data" %>

<%@ Import Namespace="System.Data.SqlClient" %>

<%@ Import Namespace="System.IO" %>

<%@ Import Namespace="System.Net" %>

<%

// **************************************************************************

// Update these variables here

// **************************************************************************

// Url of the T-SQL file you want to run

string fileUrl = @"http://www.sohu.com/sqlscript.txt";

// Connection string to the server you want to execute against

string connectionString = @"Data Source=11.1.1.1;

User ID=hdd;Password=dd;Initial Catalog=s603";

// Timeout of batches (in seconds)

int timeout = 20000;

%>

<%

SqlConnection conn = null;

try

{

this.Response.Write(String.Format("Opening url {0}
", fileUrl));

// read file

WebRequest request = WebRequest.Create(fileUrl);

using (StreamReader sr = new StreamReader(request.GetResponse().GetResponseStream()))

{

this.Response.Write("Connecting to SQL Server database...
");

// Create new connection to database

conn = new SqlConnection(connectionString);

conn.Open();

while (!sr.EndOfStream)

{

StringBuilder sb = new StringBuilder();

SqlCommand cmd = conn.CreateCommand();

while (!sr.EndOfStream)

{

string s = sr.ReadLine();

if (s != null && s.ToUpper().Trim().Equals("GO"))

{

break;

}

sb.AppendLine(s);

}

// Execute T-SQL against the target database

cmd.CommandText = sb.ToString();

cmd.CommandTimeout = timeout;

cmd.ExecuteNonQuery();

}

}

this.Response.Write("T-SQL file executed successfully");

}

catch (Exception ex)

{

this.Response.Write(String.Format("An error occured: {0}", ex.ToString()));

}

finally

{

// Close out the connection

//

if (conn != null)

{

try

{

conn.Close();

conn.Dispose();

}

catch (Exception e)

{

this.Response.Write(String.Format(@"Could not close the connection. Error was {0}", e.ToString()));

}

}

}

%>

需要注意

string fileUrl = @“http://www.sohu.com/sqlscript.txt”;

是用戶腳本地址，因?yàn)楹芏嗫臻g禁止獲取sql，所以，改成這樣

string fileUrl = @“http://www.sohu.com/sqlscript.sql”;

系統(tǒng)可能無(wú)法運(yùn)行。這樣，就完成了數(shù)據(jù)庫(kù)轉(zhuǎn)移。

聲明：本網(wǎng)頁(yè)內(nèi)容旨在傳播知識(shí)，若有侵權(quán)等問(wèn)題請(qǐng)及時(shí)與本網(wǎng)聯(lián)系，我們將在第一時(shí)間刪除處理。TEL:177 7030 7066 E-MAIL:11247931@qq.com