I usually do all my data modeling in Erwin. It then creates a script that I modify to create the tables and triggers. Once I have run the script I then create my basic stored procedures for inserting, updating, deleting using a vb app I created many years ago. All the SPs that have specific business rules I create manually from within Visual Studio against my development server. Once I have it working correctly I get a code review and sign off from testing and then run the script on the production machine.