Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2009

    Unanswered: Mysqldump for Mssql

    My over all issue is that I would like to have a pure sql file of all the data in my mssql 2008 databases. The reasoning for this is just encase the backup file glob that M$ ntbackup createsfails.

    mysql had this great little tool called myssqldump which allowed you to dump your database to a sql file. I was wondering if anyone knew of something for mssql 2008.

    I found this great utility called Microsoft SQL Server Database Publishing Wizard 1.1. which works for my 2000 & 2005 databases, but not for 2008.

    My goal is to dump all the databases to a pure sql file that would allow us to rebuild the database in the event that the backup file becomes corrupted.

    I would also like this to run as ascript every day if at all possibly.

    Download details: SQL Server Database Publishing Wizard 1.1

    could this be accomplished using the sqlcmd prompt?

    Microsoft SQL Server Management Studio 10.0.1600.22 ((SQL_PreRelease).080709-1414 )
    Microsoft Analysis Services Client Tools 2007.0100.1600.022 ((SQL_PreRelease).080709-1414 )
    Microsoft Data Access Components (MDAC) 6.0.6001.18000 (longhorn_rtm.080118-1840)
    Microsoft MSXML 3.0 6.0
    Microsoft Internet Explorer 8.0.6001.18702
    Microsoft .NET Framework 2.0.50727.3074
    Operating System 6.0.6001

  2. #2
    Join Date
    Jun 2009
    CA, USA
    You can use Visual Studio 2008 + Visual Studio 2008 SP1 to use SQL Server db publishing agianst SQL 2008.
    Connecting to Microsoft SQL Server 2008 from Microsoft Visual Studio 2005 and 2008

    you can use native or third party database backup and restores can be used.
    SQL Server MVP

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts