Moving to SQL 2005
Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: General Discussion
Forum Description: General discussion and chat on any topic.
URL: https://forums.webwiz.net/forum_posts.asp?TID=17784
Printed Date: 30 March 2026 at 6:12pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Moving to SQL 2005
Posted By: jeffdaro
Subject: Moving to SQL 2005
Date Posted: 08 January 2006 at 3:22am
|
I am moving to a new ISP, and they just upgraded all servers to SQL 2005. I know nothing about 2005. I own licenses for 2000. Any tips? Is DTS still available so I can move my database over? Where can get tools, or do I need to buy 2005? |
Replies:
Posted By: huwnet
Date Posted: 08 January 2006 at 3:43pm
| You can download SQL server 2005 express edition which is free so you can use that for development and to test conversion |
Posted By: jeffdaro
Date Posted: 08 January 2006 at 3:52pm
| Thanks, I'll check it out. |
Posted By: dpyers
Date Posted: 08 January 2006 at 4:55pm
|
I don't believe the express edition comes with any admin tools but most features of Enterprise Manager should work with it.
------------- 
Lead me not into temptation... I know the short cut, follow me. |
Posted By: WebWiz-Bruce
Date Posted: 09 January 2006 at 11:26am
|
Enterprise Manager will run with SQL 2005, and I still prefer it over
the SQL 2005 Management Studio, mainly because I'm use to the old
version. The only thing you have to watch for with SQL 2005 is that it has limitations that prevent you moving databases between different versions of SQL Server 2000 to 2005 and between different versions of SQL 2005. The Express version of SQL 2005 Management Studio, which is free, is naff and comes with no DTS import/export tools, but if you can get the full version on Management Studio it does. SQL 2005 Management Studio comes with the Developer version of SQL 2005, which I bought the other day and costs less than £50 inc. delivery, so isn't to expensive and good for developing SQL 2005 databases on. ------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |