Saving scripts

Forum for users of SQL Packager database archive utility

Moderator: David Atkinson

Saving scripts

Postby SDKyle » Mon Sep 24, 2007 9:14 pm

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
SDKyle
 
Posts: 1
Joined: Mon Sep 24, 2007 9:06 pm

Postby Chris Auckland » Thu Sep 27, 2007 5:23 am

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.
Chris
Chris Auckland
 
Posts: 757
Joined: Tue Oct 24, 2006 2:12 pm
Location: Red Gate Software Ltd.


Return to SQL Packager Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests