I need to put a database that is on MSSQL 2000 to a machine that is running
MSSQL 7. Is this possible?
There should be nothing in the 2000 db that wouldn't go back to 7. It was
created from a MSSQL7 DB.
Thanks in advance,
RobYou can't just take a sql2k db and restore/attach it to sql7. The sql2k meta
data will not be understood by sql7. Your option is to use data transfer
(i.e. import/export - dts) to move data.
-oj
"Rob rent-right com>" <ryost --nospam-- <atdot> wrote in message
news:eRj5F4iOGHA.2088@.tk2msftngp13.phx.gbl...
>I need to put a database that is on MSSQL 2000 to a machine that is running
>MSSQL 7. Is this possible?
> There should be nothing in the 2000 db that wouldn't go back to 7. It was
> created from a MSSQL7 DB.
>
> Thanks in advance,
> Rob
>|||> I need to put a database that is on MSSQL 2000 to a machine that is
running
> MSSQL 7. Is this possible?
Perhaps this is a naive unorthodox approach to the answer, but here's my
outside-the-box idea... Try it and see what happens. As an experiment you
could attempt your scenario using the SQL Server 2000 Northwind and pubs
databases to punch down to SQL 7.
> There should be nothing in the 2000 db that wouldn't go back to 7. It was
> created from a MSSQL7 DB.
As a more exhaustive experiment, you could sit at your 2000 server, make a
Foo database, and create one object of every type: 1 database, 1 table, 1
column in the table of each data type, 1 clustered index, 1 nonclustered
index, 1 constraint, 1 login, 1 custom data type, 1 stored procedure, 1
view, 1 user defined function, 1 rule...you get the idea
and then try to punch that down to SQL 7.
If you document your results and experiences, that's the kind of stuff that
SQL Server Magazine might publish. It will make you famous & get you lots
and lots of women. Either that, or just nerd-points.
--
Peace & happy computing,
Mike Labosh, MCSD MCT
Owner, vbSensei.Com
"Escriba coda ergo sum." -- vbSensei
"Rob rent-right com>" <ryost --nospam-- <atdot> wrote in message
news:eRj5F4iOGHA.2088@.tk2msftngp13.phx.gbl...
>
> Thanks in advance,
> Rob
>|||This worked, I created the database again with a sql script, and then use
import to move in the data.
Thanks,
rob
"oj" <nospam_ojngo@.home.com> wrote in message
news:%23q6AmCjOGHA.3264@.TK2MSFTNGP11.phx.gbl...
> You can't just take a sql2k db and restore/attach it to sql7. The sql2k
> meta data will not be understood by sql7. Your option is to use data
> transfer (i.e. import/export - dts) to move data.
> --
> -oj
>
> "Rob rent-right com>" <ryost --nospam-- <atdot> wrote in message
> news:eRj5F4iOGHA.2088@.tk2msftngp13.phx.gbl...
>
Friday, March 9, 2012
Move MSSQL 2000 -> MSSQL 7 (HELP!)
Labels:
database,
machine,
microsoft,
mssql,
mysql,
oracle,
possiblethere,
runningmssql,
server,
sql
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment