----------------------------------------------------------- New Message on BDOTNET
----------------------------------------------------------- From: Pandurang_Nayak Message 1 in Discussion hi there... I have a SQL Database with some data that I need to package into an installation program. One way of doing this: use the SQL Backup file, package that and run the RESTORE command. I know with Oracle, I could do this more elegantly by generating CREATE, INSERT, ALTER and UPDATE scripts (these are generated automatically by a tool) after which the whole installation script is just a series of SQL Statements that need to be executed in the order of generation. I was always under the impression that the SQL Server 2000 script generation will have a feature that will allow me to do this. But I can only script objects and not the INSERT statements in SQL Server 2000. I know there are free 3rd-party tools out there to help you do this. What I want to know is - is it possible to do this with any undocumented SQL Server 2000 feature? If not, which is the industry standard tool (or what is the industry standard practice) for achieving what I want? Srinivas/Vinod, kindly help! Regards Pandurang PS: I was almost tempted to scream out HELP and URGENT in the subject line. But haven't. However, do treat this as urgent :) ----------------------------------------------------------- To stop getting this e-mail, or change how often it arrives, go to your E-mail Settings. http://groups.msn.com/BDotNet/_emailsettings.msnw Need help? If you've forgotten your password, please go to Passport Member Services. http://groups.msn.com/_passportredir.msnw?ppmprop=help For other questions or feedback, go to our Contact Us page. http://groups.msn.com/contact If you do not want to receive future e-mail from this MSN group, or if you received this message by mistake, please click the "Remove" link below. On the pre-addressed e-mail message that opens, simply click "Send". Your e-mail address will be deleted from this group's mailing list. mailto:[EMAIL PROTECTED]
