October 31, 2007 at 11:20 pm
Hi,
I have used MS SQL server 2000. I need the procedure to create a dmp file. (that contains both query script and data script):)
November 1, 2007 at 12:31 am
You make use of the sql_dump stored procedure using the following syntax. Type it in your Query Window after connecting to the 'master' database.
exec sql_dump '-d (databasename) [-t (tablename)] [-f (outputfilename)] [-a] [-s]'
-d (databasename) : The database whose backup is to be taken
-t (tablename) : This option is to be used if you need to take the structure or data belonging to a particular table only. [Optional - If omitted then all the tables are involved in the dump process]
-f (outputfilenamewithpath) : This option is to be used if you need to specify the path and name of file to which dump is to be written. [Optional - If omitted then the dump is stored at the Backup folder found in the installation directory of MS SQL Server, with database name as the filename.]
-s : Dumps the database Schema also.
-a : Dumps the data found inside the database also.
November 1, 2007 at 4:22 pm
I've not seen any stored procedure "sql_dump" on my SQL Servers.
What are you trying to achieve? Is a backup not sufficient or are you trying to somehow add stuff from one database to another?
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy