Web Wiz - Solar Powered Eco Web Hosting

  New Posts New Posts RSS Feed - Moving to SQL 2005
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Moving to SQL 2005

 Post Reply Post Reply
Author
jeffdaro View Drop Down
Groupie
Groupie


Joined: 15 April 2005
Status: Offline
Points: 171
Post Options Post Options   Thanks (0) Thanks(0)   Quote jeffdaro Quote  Post ReplyReply Direct Link To This Post Topic: Moving to SQL 2005
    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?
Back to Top
huwnet View Drop Down
Senior Member
Senior Member


Joined: 30 May 2003
Location: England
Status: Offline
Points: 1376
Post Options Post Options   Thanks (0) Thanks(0)   Quote huwnet Quote  Post ReplyReply Direct Link To This Post 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
Back to Top
jeffdaro View Drop Down
Groupie
Groupie


Joined: 15 April 2005
Status: Offline
Points: 171
Post Options Post Options   Thanks (0) Thanks(0)   Quote jeffdaro Quote  Post ReplyReply Direct Link To This Post Posted: 08 January 2006 at 3:52pm
Thanks, I'll check it out.
Back to Top
dpyers View Drop Down
Senior Member
Senior Member


Joined: 12 May 2003
Status: Offline
Points: 3938
Post Options Post Options   Thanks (0) Thanks(0)   Quote dpyers Quote  Post ReplyReply Direct Link To This Post 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.
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9791
Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post 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.
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.07
Copyright ©2001-2024 Web Wiz Ltd.


Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Policy

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2024 Web Wiz Ltd. All rights reserved.