Move SQL Server EE databases to SQL Server Std.

I would like to know if we have sql server 2000 EE on build 818, can we
simply restore the master database and other databases to a sql server 2000
standard build 818 without issue?I doubt you can do this with the master database but the others should be
fine.
Mike Kruchten
"ECS" <xxxx@.xx.com> wrote in message
news:OjaxVZdEEHA.2660@.TK2MSFTNGP12.phx.gbl...
> I would like to know if we have sql server 2000 EE on build 818, can we
> simply restore the master database and other databases to a sql server
2000
> standard build 818 without issue?
>|||Anyone else like to comment. If this can not be done what would be the best
and easiest way to move
like 50 databases off of EE onto a standard version of MS SQL?|||Like I said you should be fine for everything except the master, and you
could try that one and see. I'm assuming you have a different machine with
Std. installed that you can test on. The only thing you really need from
master is the login info, which is easy enough to recreate.
I know the other databases work as I use this process on a weekly basis for
a test environment. I'm guessing that if you try it with master the restore
process will complain but I'm only guessing, try it and see. I know it will
complain if you try to restore a backup of master with a different service
pack level.
Mike Kruchten
"ECS" <ecs@.netset.com> wrote in message
news:uNziNjmEEHA.2768@.tk2msftngp13.phx.gbl...
> Anyone else like to comment. If this can not be done what would be the
best
> and easiest way to move
> like 50 databases off of EE onto a standard version of MS SQL?
>|||Thanks mike,
any websites to point us to for scripting the sql server logins?|||I don't have any links for you, but I'm sure there are several places that
have this info. I think you can use DTS also, though I haven't done that
myself
Here's what I use. Run these on the old system, and results of each
statement is a script you run on the new system. They can be easily modified
to include a GO between each statement, otherwise you have to run each line
individually.
--For SQL logins
SELECT 'sp_addlogin '''+
left(name + ''', ',15), --Adjust for max login length
password,
+ ', ''' +
db_name(dbid) +
+ ''', ''' +
+ language
+ ''', ',
sid,
', skip_encryption'
FROM master.dbo.sysxlogins
where srvid is null
and xstatus&4 <> 4 --isntname
order by name
--For Windows logins
SELECT 'sp_grantlogin '''+ name + ''''
FROM master.dbo.sysxlogins
where srvid is null
and xstatus&4 = 4 --isntname
and name <> 'BUILTIN\ADMINISTRATORS'
order by name
"ECS" <xxxx@.xx.com> wrote in message
news:uvyjrhqEEHA.3392@.TK2MSFTNGP11.phx.gbl...
> Thanks mike,
> any websites to point us to for scripting the sql server logins?
>