| 2 |
|
using System.Collections.Generic; |
| 3 |
|
using System.Text; |
| 4 |
|
using System.Data.SqlClient; |
| 5 |
+ |
using Microsoft.SqlServer.Management.Common; |
| 6 |
+ |
using Microsoft.SqlServer.Management.Smo; |
| 7 |
|
|
| 8 |
|
namespace AnywhereTS.DBSupport |
| 9 |
|
{ |
| 11 |
|
{ |
| 12 |
|
public MsSqlConnector(string DBServerAddress, string DBServerInstance, string DBDatabase) : base(DBServerAddress, DBServerInstance, DBDatabase) { } |
| 13 |
|
|
| 14 |
< |
public override bool ClientRunScript(string[] strCommands, out Exception ErrorInfo) |
| 14 |
> |
|
| 15 |
> |
protected override bool ClientRunScript(string strFile, out Exception ErrorInfo) |
| 16 |
|
{ |
| 17 |
|
ErrorInfo = null; |
| 18 |
|
try |
| 19 |
|
{ |
| 20 |
< |
foreach (string strCmd in strCommands) |
| 21 |
< |
{ |
| 19 |
< |
if (strCmd.Length > 0) |
| 20 |
< |
{ |
| 21 |
< |
Logging.DatabaseLog.DebugFormat("Current Command: {0}{1}",System.Environment.NewLine, strCmd); |
| 22 |
< |
// Substitute database directory with the decided one. |
| 23 |
< |
SqlCommand command = this.CreateCommandInstance(strCmd, new List<SqlParameter>(), out ErrorInfo); |
| 24 |
< |
command.ExecuteNonQuery(); |
| 25 |
< |
} |
| 26 |
< |
} |
| 20 |
> |
Server server = new Server(new ServerConnection(this.connection)); |
| 21 |
> |
server.ConnectionContext.ExecuteNonQuery(strFile); |
| 22 |
|
return true; |
| 23 |
|
} |
| 24 |
|
catch (Exception ex) |
