none
Data Import sql server 2008 to SQL 2000

    Question

  • HI All,

    How to Import data from sql server 2008 to sql server 2000 ? (i don't have any idea about SSIS, expect this any chance is there? i was try with import functionality some records are copy after it was faild i have nearly 80 Lacks records)

    Please help me how to solve this issue this is very urgent form me...

    Thanks,SAAD.

    • Moved by Tom PhillipsModerator Tuesday, September 21, 2010 1:51 PM Possibly better answer from TSQL forum (From:SQL Server Database Engine)
    • Edited by SAAD's Thursday, November 24, 2011 3:00 PM
    Tuesday, September 21, 2010 6:33 AM

All replies

  • I had an experience with the following

    1) Linked servers (moving data)

    2) Red gate  (www.red-gate.com) SQLCompare andSQLDataCompare tools


    Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/
    Tuesday, September 21, 2010 6:39 AM
    Answerer
  • Hi Dimant, thanks for ur replay

    after configure the Linked server i was try to get data it was give error message like:-

    OLE DB provider "SQLNCLI10" for linked server "Linked server name" returned message "Unspecified error".

    OLE DB provider "SQLNCLI10" for linked server "Linked server name" returned message "The stored procedure required to complete this operation could not be found on the server. Please contact your system administrator.".

    Msg 7311, Level 16, State 2, Line 1

    Cannot obtain the schema rowset "DBSCHEMA_TABLES_INFO" for OLE DB provider "SQLNCLI10" for linked server "Linked server name". The provider supports the interface, but returns a failure code when it is used.

    How to Solve the error??

    Thanks,SAAD.

    • Edited by SAAD's Thursday, November 24, 2011 3:00 PM
    Tuesday, September 21, 2010 7:00 AM
  • What stored procedure could not be found?

    SELECT * FROM ServerName.dbname.dbo.tablename WHERE.......


    Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/
    Tuesday, September 21, 2010 7:37 AM
    Answerer
  • HI,

    Simple i wrote the below Select Query only.

    select

     

    * from [Linked server name].[Database name].dbo.TableName

    Then it was given the below error message

     OLE DB provider "SQLNCLI10" for linked server "Linked server name" returned message "Unspecified error".

    Tuesday, September 21, 2010 7:40 AM
  • Hi Prasad,

    How did you created linked server mean did you created it from SQL 2000 to SQL 2008 DB or from SQL 2008 to SQL 2000 DB. I would suggest to create a linked server from SQL 2000 to SQL 2008 DB.

     


    Regards Gursethi Blog: http://ms-gursethi.blogspot.com/
    Tuesday, September 21, 2010 8:48 AM
  • And you run this query from SS2000? Meaning Linked server from SS2000 to SS2008?
    Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/
    Tuesday, September 21, 2010 9:01 AM
    Answerer
  • And you run this query from SS2000? Meaning Linked server from SS2000 to SS2008?
    Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/
    Tuesday, September 21, 2010 9:01 AM
    Answerer
  • Hi Dimant,

    Linked server configured from sql server 2008 to SQL 2000 only

    Thanks,SAAD.

    • Edited by SAAD's Thursday, November 24, 2011 3:00 PM
    Tuesday, September 21, 2010 9:06 AM