SitePoint Sponsor

User Tag List

Results 1 to 4 of 4

Thread: sql server dump

Hybrid View

  1. #1
    SitePoint Enthusiast
    Join Date
    Feb 2000
    Location
    Grand Rapids, MI
    Posts
    61
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    sql server dump

    Hello,

    In MySQL, you can do a sql dump that produces a .sql file of everything in your database (a backup, more or less). Is there a way to do this with SQL server coming in via telnet ?

    Thanks,
    Mike
    My new position : Target for Middle Management Hostility.

  2. #2
    Your Lord and Master, Foamy gold trophy Hierophant's Avatar
    Join Date
    Aug 1999
    Location
    Lancaster, Ca. USA
    Posts
    12,305
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    To do it via the command line you would use the mysqldump utility that ships with the program..

    The syntax would be similar to:
    mysqldump --opt -uUSERNAME -p databasename > /path/to/dump.sql

    You can find out more about this from the MySQL Manual.
    Wayne Luke
    ------------


  3. #3
    SitePoint Enthusiast
    Join Date
    Feb 2000
    Location
    Grand Rapids, MI
    Posts
    61
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Thanks for the reply, I don't think I was clear on my question though. I'm aware of how to do it with MySQL, I was looking for something similar in M$ SQL Server.

    Thanks,
    Mike
    My new position : Target for Middle Management Hostility.

  4. #4
    Database Jedi MattR's Avatar
    Join Date
    Jan 2001
    Location
    buried in the database shell (Washington, DC)
    Posts
    1,107
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Mike I'd use MS SQL Enterprise manager for that. If you only have isql access though, try:
    Code:
    DUMP DATABASE mydb TO 'c:\bob.dat'
    GO


Bookmarks

Posting Permissions

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