I created a sql database and filled it with some good data. Now I'm trying to move all the stored procedure over to another database instance. I exported the entire source database, including beloved stored procedures to a .sql file. Now I'm looking for a way to read that data into the other computer's sql server installation.
So far, I've tried looking through the VisualaVisual Studio UI for hints, and using sqlcmd with an input file. After using sqlcmd with the .sql file, some rows were affected, but they didn't show up in the server explorer.