Post reply

SQL 2005 Server Management Studio Import Export Wizard

  • March 11, 2009 at 11:37 am

    #384108

    Hello

    I have something really weird going on.

    I have two data center's, that are not linked in any way. The one is for our Live enviroment, the other for test.

    I have a connection to both these data center.

    So to transfer data from the one to the other (copy live messages for testing) I act as sort of a proxy between two sites.

    Here's where the problem comes in. When using Import and Export Wizard to transfer a complete table, or results from a query, only 1 row shows up in the destination table. The wizard completes with 100 rows transferred (as an example), but only one row made it to the destination.

    I've asked my colleagues to try the same thing (thought it might be something on my box) but they get the same thing.

    I did manage to find a (crappy) work around. if I drop the destination table, and let the import export wizard create it, it works !!!! Not Ideal

    Some technical info.

    Source and Destination servers are SQL 2000 SP4 (don't laugh).

    I tried this using various destination and source servers.

    Thanks for any feedback.

    regards

    Carel

  • March 11, 2009 at 12:26 pm

    #957791

    Carel,

    it will help if you describe in more details what kind of the connections you make to both servers:

    Do you have SQL 2000 Server on your computer and have 2 other servers linked?

    OR

    Do you have only Management Studio on yor computer connected to ??? and doing what? ....

    I understand you use Import and Export Wizard, but you start it on what server?

    Yelena

    Regards,Yelena Varsha

  • March 11, 2009 at 10:43 pm

    #958069

    Hello Yelena

    I have SQL 2005 Management Studio installed on my Computer. I'm just running the client tools.

    From my computer, i Start the import and export wizard. Destination server is a SQL 2000 Server SP4 in hosting area X. Source server is a SQL 2000 Server SP4 in hosting area Y.

    Regards

    Carel

  • March 12, 2009 at 9:03 am

    #958402

    When you try to append rows and have only 1 row transfered, what are the messages? In the window that shows completed export tasks, it show say "N rows transfered" where N is the number of transferred rows. You can click on this link after the execution and see details also there is a Report button and you can view and save the report. Does the report tell you something?

    It could be as easy as the primary key violation on insertion, that is why you don't have problems when re-creating the table.

    Regards,Yelena Varsha

  • September 5, 2009 at 11:01 am

    #1049767

    I am having exactly the same problem. No matter what I try in terms of options, the message and the log report indicate that all the rows (166 in my case) have been transferred, but when I look in the target table, I only see one. This is really frustrating!

    Andrew

  • September 5, 2009 at 11:10 am

    #1049768

    Carel, did you ever find a solution for this problem? I do have another (similarly crappy) workaround: Temporarily rename the Access table, export it to the Sql Server database, then do a insert into select * from

    Andrew

Viewing 6 posts - 1 through 5 (of 5 total)

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