Post reply

creating an insert script

  • September 16, 2004 at 9:12 pm

    #83981

    I need to re-create my sql database on some webspace, however I can only execute sql scripts to do this :S

    I can create the table and view scripts straight from enterprise manager which is fine, but is there a quick way to create an insert script for actual data in the required tables?

    Cheers

  • September 16, 2004 at 10:17 pm

    #523445

    Can you set up a linked server on the new server that points to the old server?  If so, you could use a bunch of INSERT .. SELECT statements to get started, at least.

    And are you sure you can't at least get permission (I'm assuming it's a permission problem) to run a DTS package, or at least use BCP?  Just this once? 

    -Chris

  • September 17, 2004 at 1:41 am

    #523463

    Could you just confirm that when you say my sql database you mean your sql server database and not MySQL database?

    If you do mean the latter then the following command will work.

    c:\mysql\bin\mysqldump your_db_name_here > c:\db_backup\mysqldb.sql

     

    LinkedIn Profile

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

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