Migration from SQL7 to SQL2000

Hi, here is my delema, I have SQL 7 running on a NT4 box and I want to move my databases over to a SQL 2000 Windows 2003 server. What is the best method. These are two different boxes. Any help is greatly appreciated.
Scott KeeganHave a look here:
http://msdn.microsoft.com/SQL/sqlmigratingdata/default.aspx
--
Andrew J. Kelly SQL MVP
"Scott Keegan" <Scott Keegan@.discussions.microsoft.com> wrote in message
news:3097FD7A-8F81-4BB9-A161-DE24A2FD40F6@.microsoft.com...
> Hi, here is my delema, I have SQL 7 running on a NT4 box and I want to
move my databases over to a SQL 2000 Windows 2003 server. What is the best
method. These are two different boxes. Any help is greatly appreciated.
> Scott Keegan|||Scott
Install SQL Server on Widows 2003 and perfom RESTORE all users databases.
It might be a collation conflict but since SQL Server 2000 you can change it
even per column.
"Scott Keegan" <Scott Keegan@.discussions.microsoft.com> wrote in message
news:3097FD7A-8F81-4BB9-A161-DE24A2FD40F6@.microsoft.com...
> Hi, here is my delema, I have SQL 7 running on a NT4 box and I want to
move my databases over to a SQL 2000 Windows 2003 server. What is the best
method. These are two different boxes. Any help is greatly appreciated.
> Scott Keegan|||Hi,
Migration from SQl 7 to SQl 2000 is straight forward, you can BACKUP and
RESTORE or use
sp_detach_db and sp_attach_db.
You could also probably also use the upgrade wizard .
Look into the below KB articles related to migration:
move the data via backup and restore
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q304692
sp_detach_db and sp_attach_db
http://support.microsoft.com/support/kb/articles/q224/0/71.asp
one more option -- the copy database wizard
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q274463
PRB: User Logon and/or Permission Errors After Restoring Dump (Q168001)
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q168001
Thanks
Hari
MCDBA
"Scott Keegan" <Scott Keegan@.discussions.microsoft.com> wrote in message
news:3097FD7A-8F81-4BB9-A161-DE24A2FD40F6@.microsoft.com...
> Hi, here is my delema, I have SQL 7 running on a NT4 box and I want to
move my databases over to a SQL 2000 Windows 2003 server. What is the best
method. These are two different boxes. Any help is greatly appreciated.
> Scott Keegan|||Is there a priority order on a where clause? Or does SQL check all of the
where clause conditions all of the time? I have a case where I can,
sometimes, hit non-numeric data in a column (caused by some bad
conversions). Right now we have the following where clause:
WHERE convert(integer, ?) BETWEEN convert(integer, low_street_num) AND
convert(integer, high_street_num)
AND (street_name = ? OR street_alias_name = ?)
AND city = ?
AND state_cd = ?
AND zip_cd LIKE ?
AND (juris_cd = ? OR juris_cd IS NULL)
AND (side = ? OR side = 'B')
AND status_cd = 'A'
AND (side = ? OR side = 'B')
AND status_cd = 'A'
I am wondering if we were to change to put the status_cd = 'A' first would
the query skip all entries whose status_cd is not 'A' and not even try to do
the convert(integer) statement at all? Or is it going to try to do the
convert(integer) regardless and my only solution is to make some routine to
fix the non-numeric data or adjust this sql to ensure the data is numeric
before trying to do the convert?
Edward Fultz
Sr. Software Engineer
Pamet Systems
Acton, Ma
www.pametsystems.com|||You cannot trust SQL Server to not hit the bad rows. Not even by pushing the filter inside a derived
table. I've been there. Put the stuff in a temp table and work against that.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Ed Fultz" <efultz@.yahoo.com> wrote in message news:O6blHRSWEHA.4056@.TK2MSFTNGP11.phx.gbl...
> Is there a priority order on a where clause? Or does SQL check all of the
> where clause conditions all of the time? I have a case where I can,
> sometimes, hit non-numeric data in a column (caused by some bad
> conversions). Right now we have the following where clause:
> WHERE convert(integer, ?) BETWEEN convert(integer, low_street_num) AND
> convert(integer, high_street_num)
> AND (street_name = ? OR street_alias_name = ?)
> AND city = ?
> AND state_cd = ?
> AND zip_cd LIKE ?
> AND (juris_cd = ? OR juris_cd IS NULL)
> AND (side = ? OR side = 'B')
> AND status_cd = 'A'
> AND (side = ? OR side = 'B')
> AND status_cd = 'A'
> I am wondering if we were to change to put the status_cd = 'A' first would
> the query skip all entries whose status_cd is not 'A' and not even try to do
> the convert(integer) statement at all? Or is it going to try to do the
> convert(integer) regardless and my only solution is to make some routine to
> fix the non-numeric data or adjust this sql to ensure the data is numeric
> before trying to do the convert?
>
> --
> Edward Fultz
> Sr. Software Engineer
> Pamet Systems
> Acton, Ma
> www.pametsystems.com
>|||You should be careful to test such a migration thoroughly:
We had a system running on MSSQL7 (MSDE) that we migrated
to MSSQL2000 Ent.Ed.
Restore finished fine, program seemded to run, but after
some days it crashed. Then nothing and then again. We
found out the following:
We built up SQL statements so string values were given as
char(65)+char(66)+...
Now, this sometimes produced queries as big as 8-9kB,
which MSSQL7 handled fine.
MSSQL2000, however, gave sql parse error. This shouldn't
be a problem until the length of the query reaches ~100kB.
Local Microsoft wanted to make this work badly, but
couldn't do it. We had to backtrack to MSSQL7.
>--Original Message--
>Hi, here is my delema, I have SQL 7 running on a NT4 box
and I want to move my databases over to a SQL 2000 Windows
2003 server. What is the best method. These are two
different boxes. Any help is greatly appreciated.
>Scott Keegan
>.
>