I have a very large database in 2000 and I'm thinking of requesting that
it be moved to 2005. I've heard that 2005 is faster and I've seen the
interface for it and it looks like it combines Query analyzer with the
standard interface tools. Enterprise Manager is just so limited and clunky.

Do you think I'd run into problems with my site if I had them update to
a new SQL database? Any pitfalls? Warnings? What should I look out for?

Is it worth it for the new security and interface features?

Thanks

I use Fluid Hosting and when they changed from 2000 to 2005 I saw no
differences. I would check the lit on what is new and more important
what changed from prior version and determine if any of it applies to
your applicaiton.

Art wrote:

> I have a very large database in 2000 and I'm thinking of requesting
> that it be moved to 2005. I've heard that 2005 is faster and I've
> seen the interface for it and it looks like it combines Query
> analyzer with the standard interface tools. Enterprise Manager is
> just so limited and clunky.
>
> Do you think I'd run into problems with my site if I had them update
> to a new SQL database? Any pitfalls? Warnings? What should I look out
> for?
>
> Is it worth it for the new security and interface features?
>
> Thanks



--

I would say wait a short while longer and upgrade to SQL Server 2008. It
seems pointless going through the upgrade now when the next version is
already on our doorstep.

A word of warning. There is no downgrade option once you have upgraded so
run the built in Upgrade Advisor before you do anything (if you have that
option) and also check that all your T-SQL code is ANSI compliant as
non-ANSI compliant code will not work in SQL 2005 or 2008. See:
http://www.sql-server-performance.co...erjoin_p1.aspx
for more info.

Also, remember that you will not have the option of scheduling any DTS
packages from 2000 as these will need to be re-built as SSIS packages if you
want them to run them as Jobs, although you can still execute them manually
(if that is a feasible option) with the assistance of the DTS add-on that is
a free download from Microsoft.

Just be very careful that all is in place before you upgrade and make sure
you take a full database backup before you upgrade (including system DB's)
in case you need to re-install 2000 and rebuild the databases.

Pat


"Philo" <meansyou@nospam.net> wrote in message
news:fr3n35$dsq$1@forums.macromedia.com...
>I use Fluid Hosting and when they changed from 2000 to 2005 I saw no
> differences. I would check the lit on what is new and more important
> what changed from prior version and determine if any of it applies to
> your applicaiton.
>
> Art wrote:
>
>> I have a very large database in 2000 and I'm thinking of requesting
>> that it be moved to 2005. I've heard that 2005 is faster and I've
>> seen the interface for it and it looks like it combines Query
>> analyzer with the standard interface tools. Enterprise Manager is
>> just so limited and clunky.
>>
>> Do you think I'd run into problems with my site if I had them update
>> to a new SQL database? Any pitfalls? Warnings? What should I look out
>> for?
>>
>> Is it worth it for the new security and interface features?
>>
>> Thanks
>
>
>
> --
>

Art wrote:
> OK, got it working...
>
> IT's very different.
>
> When I connect to the server sql 2000 I see a list of all the sites that
> are hosted on that server. That's normal. My database is way down the
> list and with the Enterprise manager, all I used to do was hit "s" and
> it would take me to the databases that started with "S". Now, when I do
> that, a warning pops up that I am not able to click on that database (if
> it's not mine).
>
> 1. Can I "hide" all but my own using the new manager?
> 2. Or, can I default to my database so it automatically opens my database?

You should be able to select your default database from the Properties
of the registered server. The second tab is called Connection
Properties, and you can select the database, but from my test, it
doesn't make much difference.

What you have to remember is that this version is a totally new build,
its based on .NET and doesn't work exactly the same as EM did.

I am sure there must be a way to only show databases that you have
access to, it would certainly make sense to only show the ones you have
access to.

Steve

Art wrote:
> Too much to learn right now; I'll have to stick with Enterprise Manager
> for now. I'll have to come back to this later.
>
> Looks interesting though.
>
> Just curious, where is the data import function? I can't seem to find that.

Yes, well, err, I think this is a limitation of the "Express" version of
SQL 2005. I don't believe import and export are available...

Steve

I hate to be the pessimist here guys but I still cannot see what you are
gaining here. Unless you are performing the full upgrade where you convert
all your DB's to 2005 (90) mode then you have nothing that you didn't have
before. In fact, you have less functionality because MS cannot utilize 200
DB's the same as EM - different engine, build etc altogether.

"Art" <lee_nospamification@artjunky.com> wrote in message
news:fr6bq6$cb8$1@forums.macromedia.com...
> yep, ctrl r worked in the old version.
>
> If everything else fails with this new version, at least I came out with
> the keyboard command...

Pat Shaw wrote:
> I hate to be the pessimist here guys but I still cannot see what you are
> gaining here. Unless you are performing the full upgrade where you convert
> all your DB's to 2005 (90) mode then you have nothing that you didn't have
> before. In fact, you have less functionality because MS cannot utilize 200
> DB's the same as EM - different engine, build etc altogether.

Someone else will have to argue with you because I have no experience
from which to argue from. The only think I got so far is the CTRL R
which works in both.

I'm hoping to work with it tonight and I'll let you know if I find
anything worthwhile.

Anyone know where the "Import" tools are?

What do you mean by the 'Import Tools'?

"Art" <lee_nospamification@artjunky.com> wrote in message
news:fr6n7g$o6u$1@forums.macromedia.com...
> Pat Shaw wrote:
>> I hate to be the pessimist here guys but I still cannot see what you are
>> gaining here. Unless you are performing the full upgrade where you
>> convert all your DB's to 2005 (90) mode then you have nothing that you
>> didn't have before. In fact, you have less functionality because MS
>> cannot utilize 200 DB's the same as EM - different engine, build etc
>> altogether.
>
> Someone else will have to argue with you because I have no experience from
> which to argue from. The only think I got so far is the CTRL R which works
> in both.
>
> I'm hoping to work with it tonight and I'll let you know if I find
> anything worthwhile.
>
> Anyone know where the "Import" tools are?

With Enterprise Manager you could work through a wizard that allowed one
to import data from different sources like an Access database on my hard
drive.

I just right click on the Tables group/all tasks/import data