title: Best practices or tools for installing a SQL Server database
body: <p>Best practices or tools for installing a SQL Server database</p>
  
  <p>I have a SQL Server database designed with the SQL Server GUI database editor/Visual Studio.</p>
  
  <p>What is the best way to "install" that database on other systems. Said another way how should I ship this thing?</p>
  
  <p>I know I can save the scripts and set the primary/foreign keys with T-SQL but I suspect their is something better. I guess you could have people restore from backup but that does not seem very professional.</p>
  
  <p>What other choices are there and what are the pluses and minuses?</p>