Working remotely on a database on SQL 7.0 using SQL 2000


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: Working remotely on a database on SQL 7.0 using SQL 2000

  1. #1
    Maria Guest

    Working remotely on a database on SQL 7.0 using SQL 2000


    I want to install SQL server 2000 on my computer and, then from here, to access
    a SQL 7.0 server.
    I am not sure if it is possible to administrate the SQL 7.0 server from SQL
    2000.
    Also, I would like to know if it is OK to do development on a database on
    SQL 7.0 using SQL 2000.

    Any help would be appreciated.

    Maria


  2. #2
    Chris Hylton Guest

    Re: Working remotely on a database on SQL 7.0 using SQL 2000


    Yes, you can access and manage a SQL Server 7.0 box from the SQL Server 2000
    Enterprise Manager...the 7.0 servers can be added and will show up in their
    own server group.

    As far as your other question...you don't have to worry about the development
    aspect from the Enterprise Manager, that's just your tool to get to the server...the
    capabilities of 7.0 and 2000 are slightly different, and you'll only have
    access to the newer features of 2000 on the machines in Enterprise Manager
    that have 2000 installed. You really aren't 'developing on 7.0 using 2000',
    hope that makes sense.

    Chris

    "Maria" <mscutaru@aci.on.ca> wrote:
    >
    >I want to install SQL server 2000 on my computer and, then from here, to

    access
    >a SQL 7.0 server.
    >I am not sure if it is possible to administrate the SQL 7.0 server from

    SQL
    >2000.
    >Also, I would like to know if it is OK to do development on a database on
    >SQL 7.0 using SQL 2000.
    >
    >Any help would be appreciated.
    >
    >Maria
    >



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