/// <summary> /// /// </summary> /// <param name="database">new database name => Required</param> /// <param name="comment">Required</param> /// <param name="group"></param> /// <param name="permissions"></param> /// <param name="location"></param> /// <returns></returns> public async Task <CreateDatabase> CreateDatabase(string database, string comment, string group, string permissions, string location) { if (string.IsNullOrEmpty(database)) { throw new Exception("database and comment are required."); } CreateDatabaseParam jsonParams = new CreateDatabaseParam { comment = comment, group = group, permissions = permissions, location = location }; CreateDatabase createDatabase = await Put <CreateDatabase>(_webHcatBaseUrl, _webHCatVersion, _webHCatUserName, requestURL.CreateDatabase(database), jsonParams); return(createDatabase); }
// This method creates a new SQL Server database public bool createDatabase(CreateDatabaseParam tInputParam) { String str; try { // Build Create database sql command str = "CREATE DATABASE " + tInputParam.sDbName + " ON PRIMARY (NAME = " + tInputParam.sDbName + "_Data, FILENAME = '" + tInputParam.sPath + tInputParam.sDbName + "Data.mdf', SIZE = " + tInputParam.sMDfSize + "MB, MAXSIZE = " + tInputParam.sMDFMaxSize + "MB, FILEGROWTH = " + tInputParam.sMDFPercentFileGrowth + "%) LOG ON (NAME = " + tInputParam.sDbName + "_Log, FILENAME = '" + tInputParam.sPath + tInputParam.sDbName + "Log.ldf', " + "SIZE = " + tInputParam.sLDFSize + "MB, MAXSIZE = " + tInputParam.sLDFMaxSize + "MB, FILEGROWTH = " + tInputParam.sIDFPercentFileGrowth + "%)"; return(executeSqlStatement(str)); } catch (SqlException ex) { MessageBox.Show(ex.Message, "Exception", MessageBoxButtons.OK, MessageBoxIcon.Error); return(false); } }