Saving scripts

SDKyle

Is there any way to automatically save the Sql scripts using the command line?

We have our own custom application similar to the .Net project you create from the packager that we want to run the scripts your tool creates. I just don't want to have to go through the user interface every time.

David

Chris Auckland

Thanks for your post, and sorry about the delay.

It is possible to use SQL Packager Command line to output scripts for both the schema and the data.

You would simply use the switches /schemascript:<schemascript>
or /datascript:<datascript> in the command.

There is more information on all the command line options by viewing the command line helpfile.

The nicest way to view the helpfile is as html, this can be created by opening a command prompt and running the following command from the SQL Packager installation directory:
SQLPackager /help /verbose /html > filename.htm

I hope this is helpful.