Professional Web Applications Themes

Help please... - Microsoft SQL / MS SQL Server

In my SQL Server 2000 (which is installed on my PC which is in Office) there is one table with following structure: MYTABLE Id char 7 Description char 255 EntityID char 47 vdata image 16 tstamp timestamp 8 This table has more than 1000 records. I have another SQL Server 2000 (which is installed on my PC at home) which also contains the similar table with the similar structure. This table has zero records. If there were only numeric or string or date type data I would have exported (from Office SQL Server) them using DTS into Excel and would ...

  1. #1

    Default Help please...

    In my SQL Server 2000 (which is installed on my PC which
    is in Office) there is one table with following structure:

    MYTABLE
    Id char 7
    Description char 255
    EntityID char 47
    vdata image 16
    tstamp timestamp 8

    This table has more than 1000 records.

    I have another SQL Server 2000 (which is installed on my
    PC at home) which also contains the similar table with the
    similar structure. This table has zero records.

    If there were only numeric or string or date type data I
    would have exported (from Office SQL Server) them using
    DTS into Excel and would have imported that Excel file
    using DTS in my Home computer.

    But as you can see above this table contains image and
    timsestamp datatype.

    My office SQL Server and home SQL Server can't be
    connected directly.

    What's the easiest way to populate my home SQL Server
    table with the records of office SQL Server table.

    Thanks.

    Sender Guest

  2. #2

    Default Re: Help please...

    Use BCP and the -N option for the native format. As long as both tables
    have the exact same structure you should be all set. Check out BCP in
    booksOnLine. And by the way, Excel is one of the worst formats for
    transferring data and should be used only when necessary.

    --

    Andrew J. Kelly
    SQL Server MVP


    "Sender" <userdomain.com> wrote in message
    news:045201c340f8$76f412c0$a501280aphx.gbl...
    > In my SQL Server 2000 (which is installed on my PC which
    > is in Office) there is one table with following structure:
    >
    > MYTABLE
    > Id char 7
    > Description char 255
    > EntityID char 47
    > vdata image 16
    > tstamp timestamp 8
    >
    > This table has more than 1000 records.
    >
    > I have another SQL Server 2000 (which is installed on my
    > PC at home) which also contains the similar table with the
    > similar structure. This table has zero records.
    >
    > If there were only numeric or string or date type data I
    > would have exported (from Office SQL Server) them using
    > DTS into Excel and would have imported that Excel file
    > using DTS in my Home computer.
    >
    > But as you can see above this table contains image and
    > timsestamp datatype.
    >
    > My office SQL Server and home SQL Server can't be
    > connected directly.
    >
    > What's the easiest way to populate my home SQL Server
    > table with the records of office SQL Server table.
    >
    > Thanks.
    >

    Andrew J. Kelly Guest

  3. #3

    Default Help please...



    Backup & Restore?
    >-----Original Message-----
    >In my SQL Server 2000 (which is installed on my PC which
    >is in Office) there is one table with following structure:
    >
    >MYTABLE
    >Id char 7
    >Description char 255
    >EntityID char 47
    >vdata image 16
    >tstamp timestamp 8
    >
    >This table has more than 1000 records.
    >
    >I have another SQL Server 2000 (which is installed on my
    >PC at home) which also contains the similar table with
    the
    >similar structure. This table has zero records.
    >
    >If there were only numeric or string or date type data I
    >would have exported (from Office SQL Server) them using
    >DTS into Excel and would have imported that Excel file
    >using DTS in my Home computer.
    >
    >But as you can see above this table contains image and
    >timsestamp datatype.
    >
    >My office SQL Server and home SQL Server can't be
    >connected directly.
    >
    >What's the easiest way to populate my home SQL Server
    >table with the records of office SQL Server table.
    >
    >Thanks.
    >
    >.
    >
    Guest

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
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139