Go Back  DVD Talk Forum > General Discussions > Tech Talk
Reload this Page >

Moving From SQL 7 to SQL 2K

Tech Talk Discuss PC Hardware, Software, Internet and Other Technology

Moving From SQL 7 to SQL 2K

Old 07-26-05, 11:18 AM
  #1  
DVD Talk Legend
Thread Starter
 
Join Date: Feb 2003
Posts: 14,204
Likes: 0
Received 0 Likes on 0 Posts
Moving From SQL 7 to SQL 2K

At a client site, they have two instances of SQL running... the main one is 7.0, and then they have a second instance using SQL 2000.

They now want to migrate everything into SQL 2000... from a developer standpoint, I can do this. (Tables, views, users, roles, etc.) But from a network standpoint... what would be the quickest and easiest way to change over?

Example: the SQL 7.0 server is called MOJO, and the SQL 2000 server is called MOJO\TEST. All of my connection strings point to MOJO, and I don't want to have to change them all. How can I change my settings so that the server name MOJO points to MOJO\TEST?

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is On
Trackbacks are Off
Pingbacks are Off
Refbacks are Off


Thread Tools
Search this Thread

Archive - Advertising - Cookie Policy - Privacy Statement - Terms of Service - Do Not Sell My Personal Information

Copyright 2018 MH Sub I, LLC dba Internet Brands. All rights reserved. Use of this site indicates your consent to the Terms of Use.