Results 1 to 4 of 4

Thread: thanks.

  1. #1
    Join Date
    Feb 2002
    Posts
    17

    Unanswered: thanks.

    Thanks Satya, but problem with FTP is , its getting disconnected after around 2-3 GB . then again i have to start from the beginning, wasting whole lot of time.

    Is there any good FTP client s/w or any other better solutions ?

    Thanks.

    Hadle

  2. #2
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    Refer to my thread and try-
    Even you can use Generate SQL Scripts and run those scripts on the local machine, then use DTS to transfer the data.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  3. #3
    Join Date
    Feb 2002
    Posts
    17
    Satya,

    I have read your thread , and have started DTS also, but u know, since it is like 5GB of size , its going to take a whole day.

    thats why i asked you, is there any other option ?

  4. #4
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    In that case you can divide the DTS task to complete few thousands rows tables first and then big tables during other times.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

Posting Permissions

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