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 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply