Importing Stored Procedures from saved SQL (.sql) files.

[online6]

I frequently use the "Generate Script" wizard to create a folder of .sql files (scripts) that I use to then transfer to my colleagues.

The question is, I don't see how to reverse the procedure, that is, to import the files with a bulk procedure, rather than copying them one at a time. What's the best way to do this?

thanks

[nosepicker]

When you create the script, you can choose to write multiple objects into a single script instead of separate scripts. Or, you can use the "type" command from the command line to combine text files into one:

type c:\*.sql > combinedfile.txt

[online6]

I know I have the option of creating a single file. How does that help with importing all the scripts?

thanks

[nosepicker]

I assume that when you say you want to "import the files", you want to be able to recreate the objects that were scripted (tables, stored procedures, functions, etc.). Simplest way to recreate them is to copy the script into a Query Analyzer window and execute the script. If all your scripts are combined, you can recreate them all together in one shot.

If you want a more automated way to recreate the objects, you can use the "osql" command from the command line:

osql -Uuserid -Ppassword -Sservername -ddatabasename < c:\YourScriptName.sql

If you don't specify a database, the objects in the script will be created in the master database by default.

[mulhall]

online6 it sounds like you're not getting the CREATE commands in your scripts.

When generating scripts, check the formatting tab and that the 'Generate the CREATE command for each object' is checked. This is the default behaviour but might be your prob.

[online6]

Yep ... Did the trick using the Query Analyzer.. Just one more question. I need to put the directive "Use db.." as the first
line so when I execute it, it uses the correct DB. Anyway I can modify the template when I generate the script to do that?

Thanks