Home ›
ASP.NET Forums » Data Access » SQL Server, SQL Server Express, and SqlDataSource Control » How to export MSSQL2000 DB to *.sql?

How to export MSSQL2000 DB to *.sql?

Last post 05-09-2008 9:55 AM by XPSCodes. 2 replies.

Sort Posts:

  • How to export MSSQL2000 DB to *.sql?

    05-09-2008, 9:20 AM

    Hi

    May I ask how to export MSSQL2000 DB to *.sql with all existing data?

    As I built the DB on local machine, the remote machine only provide SQL Server Web Admin which has Query Analyzer only. I can export a *.sql file, but there are no data. 

    Thanks for help

     

     

     

  • Re: How to export MSSQL2000 DB to *.sql?

    05-09-2008, 9:54 AM
    • Loading...
    • kipo
    • Joined on 07-20-2006, 7:10 AM
    • Croatia
    • Posts 1,122

    Try with Database Publishing wizard: http://www.microsoft.com/downloads/details.aspx?familyid=56E5B1C5-BF17-42E0-A410-371A838E570A&displaylang=en

  • Re: How to export MSSQL2000 DB to *.sql?

    05-09-2008, 9:55 AM
    • Loading...
    • XPSCodes
    • Joined on 03-11-2008, 11:17 PM
    • New Jersey
    • Posts 404

     Check this http://www.codeproject.com/KB/database/ScriptDatabase.aspx

    Save our world, its all we have! A must watch video Pale Blue Dot

    Please use the search feature of the forum before asking a question.
Page 1 of 1 (3 items)
RSS Available

Advertise on ASP.NET

About this Site