The problem here is that I'm moving 20 domains from a SQL7 machine to a SQL2000 machine on a different hosting company. I have 20 domains to mov e and I can't move them all instantly. For some weeks I'm going to have to work with both. And my major client has SQL7 and isn't going to upgrade any time soon. So I have to continue to work with both.
I don't own SQL2000 - my hosting company does. I own SQL7. I have t he SQL7 Enterprise Manager. How can I work with the SQL2000 databases? And where can I (legally) get the SQL2000 Enterprise manager without owni ng SQL2000 Server? Cheers, Mike Kear Windsor, NSW, Australia AFP WebWorks -----Original Message----- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Monday, December 24, 2001 6:25 AM To: CF-Talk Subject: RE: SQL7 and SQL2000 on the same machine - how? > But my SQL7 EM (enterprise manager) doesn't work with SQL2000. > I can install MSDE from my Office2000 CD, but when I do it says > I have EM installed and it is not allowed. > > I could use Access, but that has different table structures > and datatype names and the SQL is different. I'd rather work > directly in the SQL Environment if I can. > > Does anyone know how I can get round this? Can I have both > SQL7 and SQL2000 tools installed on the same machine? No, not exactly. You can have both SQL Server 7 and SQL Server 2000 installed on the same machine, if you do it correctly, but once you insta ll SQL Server 2000, it will replace your SQL Server 7 client tools (Enterpri se Manager, etc) with the SQL 2000 versions of those tools. You can use the 2000 versions to administer SQL Server 7. For local development purposes, you might find it easier to simply migrat e all of your local SQL 7 databases to SQL 2000. There's very little difference, and you can easily transfer data from SQL 2000 to SQL 7. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ______________________________________________________________________ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation � $99/Month � Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
