Product Suggestion: Save scripts individually

Forum for users of SQL Packager database archive utility

Product Suggestion: Save scripts individually

Postby skirilov » Wed Mar 11, 2009 5:55 pm

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?
Posts: 2
Joined: Wed Mar 11, 2009 5:51 pm

Postby David Atkinson » Wed Mar 11, 2009 9:57 pm


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.


David Atkinson
Product Manager
Red Gate Software
David Atkinson
Posts: 1143
Joined: Mon Dec 05, 2005 3:54 pm
Location: Twitter: @dtabase

Postby skirilov » Thu Mar 12, 2009 1:54 pm

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.
Posts: 2
Joined: Wed Mar 11, 2009 5:51 pm

Postby Chris Auckland » Thu Mar 12, 2009 4:33 pm


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 Auckland
Posts: 760
Joined: Tue Oct 24, 2006 1: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