Red Gate forums :: View topic - Data Script not getting created
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

Data Script not getting created

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



Joined: 10 Feb 2011
Posts: 2

PostPosted: Thu Mar 17, 2011 8:37 pm    Post subject: Data Script not getting created Reply with quote

I am trying to create a script for our build process that will create a new db from scratch so that I can include it with our installer.

I'm Calling the Sql Packager like this

Code:
SQLPackager.exe /argfile:c:\temp\PackageSettings.xml


Here is the contents of PackageSettings.xml:

Code:

<?xml version="1.0"?>
<commandline>
   <force/>
   <verbose/>
   <out>c:\temp\output.txt</out>
   
   <makescript/>
   <scriptdestination>c:\temp</scriptdestination>
   
   <server1>localhost</server1>
   <database1>MyDb</database1>    
      
   <schemascript>c:\temp\CreateDB.sql</schemascript>
   <datascript>c:\temp\DefaultData.sql</datascript>
   
   <includeschema>Table</includeschema>
   <includeschema>StoredProcedure</includeschema>
   <includeschema>View</includeschema>
   
   <includedata>Table</includedata>

</commandline>


With the above set up, I only get CreateDB.sql. It never creates DefaultData.sql.

How do I get it to make the data script?

If I could get it to make a single script like the GUI does that would be even better.

I have not seen the scriptdestination tag make any difference. What does it affect? Why is it required if it doesn't change anything?
Back to top
View user's profile Send private message
leosperry



Joined: 10 Feb 2011
Posts: 2

PostPosted: Thu Mar 17, 2011 11:08 pm    Post subject: Fixed, But Why? Reply with quote

I had to run as an admin 1 time. Now it works. I was getting some kind of error that asked to run as an admin.

My environment is Win 7 64bit
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