| Author |
Message |
leosperry
Joined: 10 Feb 2011
Posts: 2
|
 Posted: Thu Mar 17, 2011 8:37 pm Post subject: Data Script not getting created |
 |
|
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 |
|
 |
leosperry
Joined: 10 Feb 2011
Posts: 2
|
| Posted: Thu Mar 17, 2011 11:08 pm Post subject: Fixed, But Why? |
|
|
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 |
|
|
|
|
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
