Red Gate forums :: View topic - Saving scripts
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Packager Previous Versions
SQL Packager Previous Versions forum

Saving scripts

Search in SQL Packager Previous Versions forum
Post new topic   Reply to topic
Jump to:  
Author Message
SDKyle



Joined: 24 Sep 2007
Posts: 1

PostPosted: Mon Sep 24, 2007 9:14 pm    Post subject: Saving scripts Reply with quote

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
Back to top
View user's profile Send private message
Chris Auckland



Joined: 24 Oct 2006
Posts: 757
Location: Red Gate Software Ltd.

PostPosted: Thu Sep 27, 2007 5:23 am    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group