Posted by DickChristoph on 03/02/06 02:08

Hi Sarah Lin,

I would bet dollars to donuts that your data is identical. Permissions could
be complicated since they are stored by and id number not by name
(permissions to dchristo on Server1 are not going to translate to dchristo
on Server2).

I would be most concerned that the stored procedures and SQL Code used to
access your database continue to work as advertised. Particularly if any
column or table names in the SQL 7 database are now reserved words in SQL
2000. (I seem to recall having trouble with a column called "Level")

--
-Dick Christoph
<sarahlin@yahoo.com> wrote in message
news:1141166493.530739.45340@u72g2000cwu.googlegroups.com...
> YES I am!! I was indeed looking into a different database.
> One quick follow up question, is there any tool that I can use to make
> sure that the restored database is "completely" identicial? say,
> premission, or data.
>
> Thanks!!
>
> -sarah
>

• Next in forum: Re: How to have strings automatically truncated?
• Prev in forum: Re: Use MS SQL Server 2005 Developer version to open MDF file?
• Thread view: Re: restore sql 7db to sql2000

[Reply to this message]