Post reply

SQL server database backup without data possbile ?

  • January 24, 2006 at 6:43 am

    #167265

    While exporting schema or database (backup better) from SQL server do we have any option to export the

    Schema without any data like Oracle (exp utility, ROWS =N) we have??

  • January 24, 2006 at 3:26 pm

    #616774

    You can script out tables in Enterprise Manager or Query Analyzer.  You can also export table schema without data to another database using the DTS Import/Export wizard.  Just choose 'Copy objects and data between SQL Server databases' and make sure you uncheck the 'copy data' option.

    Greg

    Greg

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply