Connecting Sql 6.5 to 7.0


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: Connecting Sql 6.5 to 7.0

  1. #1
    Jasjeet Singh Guest

    Connecting Sql 6.5 to 7.0


    I have three sql 6.5 Server running and one sql 7.0 (trial version). I want
    to transfer data from one of the 6.5 to 7.0
    for different databases and I am unable to do so.

    Its says couldn't create a Instance of DTS package.

    or something like I will have to upgrade my sql 6.5 to sql 7.0 and then perform
    the transfer.

    Please let me know if there is a way to do so or not...


    Share on Google+

  2. #2
    Rob Vieira Guest

    Re: Connecting Sql 6.5 to 7.0

    The transfer(s) should be initiated by the 7.0 server. It's also possible
    that you'll need to run an updated version of a file called instcat.sql to
    update some things on the 6.5 server, but that shouldn't generally be
    necessary.

    Personally, I recommend using ODBC to connect to the 6.5 servers - it seems
    to create less hassles. To really respond to this one further, I would need
    more specific information on the way that your package is set up and the
    explicit error being created.


    --
    Rob Vieira MCSD, MCT, MCDBA
    www.ProfessionalSQL.com

    "Jasjeet Singh" <singh@craftsamericana.com> wrote in message
    news:3a6f2ba4$1@news.devx.com...
    >
    > I have three sql 6.5 Server running and one sql 7.0 (trial version). I

    want
    > to transfer data from one of the 6.5 to 7.0
    > for different databases and I am unable to do so.
    >
    > Its says couldn't create a Instance of DTS package.
    >
    > or something like I will have to upgrade my sql 6.5 to sql 7.0 and then

    perform
    > the transfer.
    >
    > Please let me know if there is a way to do so or not...
    >
    >



    Share on Google+

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center