Hi there, we tried to restore a sql 7 DB to sql2000, somehow some of
the varchar filed become nvarchar, why is this?
thanks,
-sarah
the varchar filed become nvarchar, why is this?
thanks,
-sarah
-
-
Re: restore sql 7db to sql2000
(sarahlin@yahoo .com) writes:[color=blue]
> Hi there, we tried to restore a sql 7 DB to sql2000, somehow some of
> the varchar filed become nvarchar, why is this?[/color]
Sounds like you are victim to a mirage. That does simply just not happen.
You may be mistaken about the source database. Or you are looking into
the wrong database on the target server.
--
Erland Sommarskog, SQL Server MVP, esquel@sommarsk og.se
Books Online for SQL Server 2005 at
Books Online for SQL Server 2000 at
-
Re: restore sql 7db to sql2000
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
Comment
-
Re: restore sql 7db to sql2000
(sarahlin@yahoo .com) writes:[color=blue]
> 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.[/color]
I guess Red Gate's SQL Compare could do the job. But I have not used
it myself, so I don't know how far it goes.
--
Erland Sommarskog, SQL Server MVP, esquel@sommarsk og.se
Books Online for SQL Server 2005 at
Books Online for SQL Server 2000 at
Comment
-
Re: restore sql 7db to sql2000
I use SQL Compare frequently. It is awesome. I do not know, however, if
you can compare SQL7 to SQL2000. That seems reasonable enough ;).
Comment
-
Re: restore sql 7db to sql2000
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@u 72g2000cwu.goog legroups.com...[color=blue]
> 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
>[/color]
Comment
Comment