how to dump a MSSQL DB?

eantoranz · 07-04-2013, 11:37 AM

Hi!

I'm on a linux box and I connect to a MSSQL db through squirrel (by means of jtds). I'm wondering if it's possible to create a dump of a DB so that I could recreate from scratch so that I can tests some scripts on it.

Thanks in advance.

TB0ne · 07-04-2013, 01:31 PM

Quote:

Originally Posted by eantoranz

Hi!
I'm on a linux box and I connect to a MSSQL db through squirrel (by means of jtds). I'm wondering if it's possible to create a dump of a DB so that I could recreate from scratch so that I can tests some scripts on it.

Thanks in advance.

The obvious question is, does squirrel have a means of exporting/save-as the file/tables you're reading? If so, just export it to a CSV file, and re-import it to another DB.