Red Gate forums :: View topic - Product Suggestion: Save scripts individually
Return to www.red-gate.com RSS Feed Available

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

Product Suggestion: Save scripts individually

Search in SQL Packager 6 forum
Post new topic   Reply to topic
Jump to:  
Author Message
skirilov



Joined: 11 Mar 2009
Posts: 2

PostPosted: Wed Mar 11, 2009 6:55 pm    Post subject: Product Suggestion: Save scripts individually Reply with quote

We used to use SQL Packager 5 and loved the feature that allowed us to save the schema and data script separately, but that feature is gone in SQL Packager 6. Can you guys put that functionality back in for a future release, or is there still a way of doing this?
Back to top
View user's profile Send private message
David Atkinson



Joined: 05 Dec 2005
Posts: 1121
Location: Twitter: @dtabase

PostPosted: Wed Mar 11, 2009 10:57 pm    Post subject: Reply with quote

Hi,

Thanks for the request. Can I ask what the scenario is that requires you to save the scripts off as separate files?

One way of doing it currently is to select all the text from the Schema and Data Scripts, copy to the clipboard and paste this into a text file.

Regards,

David Atkinson
Product Manager
Red Gate Software
Back to top
View user's profile Send private message Send e-mail
skirilov



Joined: 11 Mar 2009
Posts: 2

PostPosted: Thu Mar 12, 2009 2:54 pm    Post subject: Reply with quote

We currently use SQL Packager to package our database, into 2 files. A schema file, and a data file, which get added to our build process as a starting point, on which we build other scripts.

We are aware that we can copy and paste from the windows, but the scripts that are generated are roughly 20,000 lines and 70,000 lines, which tends to really bog down our machines when we try and copy and paste that much information.
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 Mar 12, 2009 5:33 pm    Post subject: Reply with quote

Hi,

You can still export individual schema and data scripts if you use the SQL Packager command line interface.

Switches /schemascript /datascript should do what you need.

There is information on using the command line interface in SQL Packager helpfile.

I hope this is helpful.

Let me know if you need any more information.
_________________
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