Results 1 to 8 of 8
  1. #1
    Join Date
    Jan 2003
    Posts
    15

    Unanswered: export data into insert statements

    is there any tools to do so? export everything into a lot of insert statements. i mean those free tools or scripts

  2. #2
    Join Date
    Feb 2002
    Posts
    2,232
    What are you trying to do ?

  3. #3
    Join Date
    Jan 2003
    Posts
    15
    it is for my web-based application, which checks database version to determine whether it is valid. if not valid, just execute all pre-defined sql scripts. can help customers to install the web-based application.
    Last edited by timothymo; 12-19-03 at 01:37.

  4. #4
    Join Date
    Dec 2003
    Location
    Toronto
    Posts
    15
    This link may help you:
    http://www.red-gate.com/SQL_Compare.htm
    But it's not free stuff....

  5. #5
    Join Date
    Jan 2003
    Posts
    15
    Thanks guys. Just found a tool from msdn web site: sqlwebadmin. a bit similar to phpmyadmin. can export everything into scripts. but it got problem with large database. but at least can use

  6. #6
    Join Date
    Feb 2002
    Posts
    2,232
    Did you mean you wanted to script your database - creating the database, tables, constraints ... If so, then you can script it through Enterprise Manager.

  7. #7
    Join Date
    Jan 2003
    Posts
    15
    Em doesn't script data.

  8. #8
    Join Date
    Feb 2002
    Posts
    2,232
    For those of you who want to download this tool:

    tool

Posting Permissions

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