SQL packager add data even after /excludedata
nirmal80_in
Posts: 6
Hi
I am kind of new to SQL Packager. But one problem which i am currently facing is.
I only want to package the database schema and no data. I specify to exclude the table data but even then it includes the data for those tables which have any views defined on them. I tried to add views to the /excludedata switch but that does not works. Kindly help me out
I don't want any table data in any circumstances. Below is pasted the command which i am running from the command line.
"C:\Program Files\Red Gate\SQL Bundle 5\SQLPackager.exe" /quiet /database1:xxx /server1:xxx /makeexe /name:xxxxx_Schema_1782006 /location:C:\Schema_Scripts /schemascript:c:\Schema.sql /rundb:Schema /databasedirectory:C:\Data /logdirectory:C:\Data /recoverymodel:Simple /force /excludedata:Table.
I am kind of new to SQL Packager. But one problem which i am currently facing is.
I only want to package the database schema and no data. I specify to exclude the table data but even then it includes the data for those tables which have any views defined on them. I tried to add views to the /excludedata switch but that does not works. Kindly help me out
I don't want any table data in any circumstances. Below is pasted the command which i am running from the command line.
"C:\Program Files\Red Gate\SQL Bundle 5\SQLPackager.exe" /quiet /database1:xxx /server1:xxx /makeexe /name:xxxxx_Schema_1782006 /location:C:\Schema_Scripts /schemascript:c:\Schema.sql /rundb:Schema /databasedirectory:C:\Data /logdirectory:C:\Data /recoverymodel:Simple /force /excludedata:Table.
Comments
How to exclude both table data and view data from sqlpackager command line..
Apparently sqlpackager.exe doesn't accept /excludedata:View. We'll need to look deeper into this to find the reason. Thanks for pointing it out.
Thanks for looking into my request. Now can you give me a certain timeline by which I should be getting a solution from your side on this.
I am kind of stuck big time because of this.
I hope you would understand my urgency.
Thanks,
Nirmal
I need to contact one of the development staff. It clearly says in the packager 'help' (sqlpackager /verbose /?) that you can use /excludedata:View, but then the program doesn't accept the argument. If the product is not working as designed, this is a bug in my books!
Please update me ASAP as to when should I expect this issue/bug to be resolved.
Also do I have to log this bug/issue anywhere else besides this forum.
Thanks,
Nirmal
I have posted this bug to the support@red-gate.com. But haven't got any reply from their side.
Will I be getting back any tracking no. for this or not ?? Is there anyway by which I can get to know how long will it take to get this issue resolved.
Awaiting ur reply..
Thanks,
Nirmal