title: Approach to import/export SQL Server stored procedures
body: <p>I know most people will give responses like, right click database name, select task, generate scripts, etc. Most people give detail response on the internet include stackoverflow</p>
  
  <p>I already know that long time ago.</p>
  
  <p>My question is any suggestions to write scripts to export/import stored procedures. If I only have to do 5 or 10, it is no big issue. I just have to pick right ones. If there are lots like 50 or more, it is pain and bound to be errors. Sometimes, to make life easier, we want to export/import with suffix such as <code>*test.sql</code>.</p>
  
  <p>Any suggestion using SQL scripts, C# or dos commands to do so?</p>
  
  <p>Thanks </p>