Skip to content

Home

Jump to bottom
Zindur edited this page Dec 15, 2017 · 1 revision

Welcome to the MSSQL-DumpTable wiki!

This script should generate a dump of a table in 2 formats as "INESRT INTO ... VALUES ..." and "SELECT ... FROM VALUES ..."

see parameter: @BuildMethod = 1 or 2

SQL must have permission to create files, if is not set-up then exec follow line once EXEC sp_configure 'Ole Automation Procedures', 1; RECONFIGURE WITH OVERRIDE;

Scripts are created as @SchemaName + _ + @TableName + .sql if you vould like to save with other name then populate param : @AsFileName

And script will be created into path @PathOut and note: this path must already exists !!!

Clone this wiki locally