Post reply

Copy contents of one table from one server to another

  • May 10, 2004 at 5:47 am

    #161913

    I'm looking for an easy way of asking a client to copy the contents of one table from his server, and email the result to me.

    I could ask him to mail me a backup, but a 25 GB DB cannot fit onto a single CD Rom, even when zipped, and all I want is 50 records from a small setup table.

    I've had to ask him to do a "select * from mytable" in QA, and then type the data in myself.

    Is there an easier way ?

    TIA

    Henrik Staun Poulsen

    Stovi Software, Denmark

     

     

  • May 10, 2004 at 6:08 am

    #505772

    If I understand your question correctly (obtain 50 rows via email), have your 'partner' export the 50 rows to a comma or tab delimited text file, zip it and then send it to you.  When you receive it, unzip and bcp in or bulk insert into your table.  Sounds so easy, I'm almost sure I'm missing something..

  • May 10, 2004 at 6:45 am

    #505776

    Darell,

    Thank you. I had forgotten about the Export wizard.

    Regards

    Henrik

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

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