Trustworthy Databases

Comments

• David Atkinson Redgate › Posts: 1,458 Rose Gold 2

  July 28, 2008 12:27PM

  Hi James,
  
  Currently it is not possible to amend the SQL Script that SQL Packager outputs, so adding the line "ALTER DATABASE [IOS01] SET TRUSTWORTHY ON" is sadly not an option.
  
  However, we are tentatively looking into the possibility of allowing SQL Packager to read in its input from a file, which should allow for a lot more flexibility.
  
  If anyone else knows of any instances of where editing the Packager script may solve an existing problem, please respond to this thread or email me personally, as this will add weight to this enhancement candidate.
  
  Regards,
  
  David Atkinson
  Product Manager
  Red Gate Software
  David.Atkinson at red-gate.com

  David Atkinson
  Product Manager
  Redgate Software

  0 · Share on Twitter
• james.taylor Posts: 6

  July 28, 2008 12:38PM

  David,
  
  Thanks for the response.
  
  I do have another reason for requiring the ability to alter/modify the script. This would be to modify the default passwords that the Redgate applications apply by default to their user creation scripts.
  
  At our company we do have standard fixed users and passwords that our applications use internally. The ability to change these would be an ideal enhancement to the Packaging application.
  
  Failing that, is there anyway of altering the default passwords that your script generators use?

  0 · Share on Twitter
• tchaplin@miningis.com.au Posts: 20

  September 3, 2008 11:30PM

  I got this to work by hacking the PackageExecutor.cs file in Red Gate\SQL Packager 5\SQL Packager Code Templates\C#
  

  sqlCommand.CommandText = "ALTER DATABASE " + m_DatabaseName + " SET TRUSTWORTHY ON";
  sqlCommand.ExecuteNonQuery();
  

  
  I put it just under this code:
  

  string [] dbOptions = m_DatabaseProperties.DatabaseOptions;
  					if (dbOptions != null)
  					{
  						foreach (string dbOption in dbOptions)
  						{
  							try
  							{
  								if (dbOption.Length > 0)
  								{
  									sqlCommand.CommandText = "Exec sp_dboption '" + m_DatabaseName + "', '"+ dbOption +"' ,'on'";	
  									sqlCommand.ExecuteNonQuery();
  								}
  							}
  							catch 
  							{
  								//MessageBox.Show(sqlCommand.CommandText,e.Message, System.Windows.Forms.MessageBoxIcon.Information);
  							}
  
  
  							//node.Nodes.Add(string.Format("db_option '{0}', 'on'", dbOption));	
  						}				
  					}
  

  
  It would be great if the ability to set all database options was made available in the future.

  0 · Share on Twitter
• tchaplin@miningis.com.au Posts: 20

  September 4, 2008 1:11AM

  Is it possible to have multiple SQL Packager Code Templates and specify which one to use when packaging?
  
  I have to do custom editing to the template for each of our different products.

  0 · Share on Twitter