Red Gate forums :: View topic - Command line API questions
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

Command line API questions

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



Joined: 22 Dec 2011
Posts: 3
Location: Herzelya, Israel

PostPosted: Mon Dec 26, 2011 10:48 am    Post subject: Command line API questions Reply with quote

What Iím trying to achieve is to generate an executable file from a script using the SqlPackager command line interface. The script file contains two parts:
1. The result script of a schema comparison (using SqlCompare)
2. A script file that contains code for inserting/merging static data.
Iím using a power shell batch to combine the files (extracting the content of the scripts and adding it to a new file one after the other).
I also tried packaging just the static data insertion script. The package raised SQL errors when I tried to execute it on the target database, as if the packager did not package the entire script.
1. Is it at all possible to create a package from a script which is not a schema script, i.e. a script which is inserting data to tables?
2. Is it ok to combine scripts textually and package them to one exe file?
_________________
Ran Shani
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6643

PostPosted: Tue Dec 27, 2011 12:13 pm    Post subject: Reply with quote

Hi Ran,

Yes that shoudl be fine. Please let us know what errors you get. We have opened a support call for this already so if you have anything to send please respond to the email that we sent you when we opened the call.
Back to top
View user's profile Send private message
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