async private void btnOK_Click(object sender, EventArgs e)
{
try
{
Cursor = Cursors.WaitCursor;
SqlFDB fdb = new SqlFDB();
if (CreateFromMDF && MdfFilename != String.Empty)
{
await fdb.Open(ConnectionString);
if (!fdb.Create(txtDatabase.Text, MdfFilename))
{
MessageBox.Show(fdb.LastErrorMessage, "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
}
else
{
await fdb.Open(ConnectionString);
UserData parameters = _advancedSettings.ToUserData();
if (btnOnlyRepository.Checked)
{
parameters.SetUserData("CreateDatabase", false);
}
if (!fdb.Create(txtDatabase.Text, parameters))
{
MessageBox.Show(fdb.LastErrorMessage, "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
if (chkCreateReplicationDatamodel.Checked == true)
{
if (!await gView.Framework.Offline.Replication.CreateRelicationModel(fdb))
{
MessageBox.Show("RepliCreateRelicationModel failed:\n", "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
if (chkCreateConnection.Checked)
{
string connStr = FullConnectionString;
ConfigTextStream stream = new ConfigTextStream("sqlfdb_connections", true, true);
string id = txtObject.Text;
stream.Write(FullConnectionString, ref id);
stream.Close();
_resultExObject = new SqlFDBExplorerObject(null, id, FullConnectionString);
}
this.Close();
}
catch (Exception ex)
{
MessageBox.Show("FATAL ERROR: " + ex.Message);
}
finally
{
Cursor = Cursors.Default;
}
}
static int Main(string[] args)
{
string server = "", uid = "", pwd = "", database = "", mdf = String.Empty;
UserData userData = new UserData();
for (int i = 0; i < args.Length - 1; i++)
{
if (args[i] == "-server")
{
server = args[++i];
}
if (args[i] == "-uid")
{
uid = args[++i];
}
if (args[i] == "-pwd")
{
pwd = args[++i];
}
if (args[i] == "-database")
{
database = args[++i];
}
if (args[i] == "-mdf")
{
mdf = args[++i];
}
if (args[i].StartsWith("-_"))
{
userData.SetUserData(args[i].Substring(2, args[i].Length - 2), args[++i]);
}
}
if (server == "" || database == "")
{
Console.WriteLine("USAGE:");
Console.WriteLine("gView.Cmd.CreateSqlFDB -server <SQL Server Instance>");
Console.WriteLine(" -database <Database Name>");
Console.WriteLine(" [-uid <User>]");
Console.WriteLine(" [-pwd <Password>]");
Console.WriteLine(" [-mdf <mdf_file_path>");
Console.WriteLine(" [-_Parametername <parameter>]");
Console.WriteLine("Example:");
Console.WriteLine("CreateSqlFDB -server localhost -database NEW_FDB -_filename c:\\myDatabase.mdf -_size 300 -_filegrowth 50");
return(1);
}
// Path setzen, damit in fdb.Create die createdatabase.sql gefunden wird...
/*
* if (SystemVariables.RegistryApplicationDirectory != "")
* {
* SystemVariables.ApplicationDirectory = SystemVariables.RegistryApplicationDirectory;
* }
*/
string connectionString = "server=" + server;
if (uid != "")
{
connectionString += ";uid=" + uid + ";pwd=" + pwd;
}
else
{
connectionString += ";Trusted_Connection=True";
}
SqlFDB fdb = new SqlFDB();
if (!fdb.Open(connectionString))
{
Console.WriteLine("ERROR :" + fdb.lastErrorMsg);
fdb.Dispose();
return(1);
}
if (!String.IsNullOrEmpty(mdf))
{
if (!fdb.Create(database, mdf))
{
Console.WriteLine("ERROR :" + fdb.lastErrorMsg);
fdb.Dispose();
return(1);
}
}
else
{
if (userData.UserDataTypes.Length > 0)
{
Console.WriteLine("CREATE DATABASE " + database + " ON PRIMARY (NAME=" + database + ",");
foreach (string type in userData.UserDataTypes)
{
Console.WriteLine(type + "=");
if (type.ToLower() == "filename")
{
Console.WriteLine("'" + userData.GetUserData(type) + "'");
}
else
{
Console.WriteLine(userData.GetUserData(type));
}
}
Console.WriteLine(")");
}
if (!fdb.Create(database, userData))
{
Console.WriteLine("ERROR :" + fdb.lastErrorMsg);
fdb.Dispose();
return(1);
}
}
fdb.Dispose();
Console.WriteLine("...done");
return(0);
}
