migrate from SQL 2000 to SQL 2008 R2

[iccsi]

I tried to move my view from SQL 2000 to SQL 2008 R2.
Once I run the scripts, I realized that my SQL 2000 views becomes SQL
2008 R2 tables.
I am unable to view as SQL if I need do some modifiction for the
table.
Is it normal that SQL Server 2008 R2 convert SQL 2000 view to a table?

Are there any way to have thme in the view to modify the SQL, link
table and criteria?

Your information and help is great appreciated,

Regards,


iccsi

[Erland Sommarskog]

Post by iccsi
I tried to move my view from SQL 2000 to SQL 2008 R2.
Once I run the scripts, I realized that my SQL 2000 views becomes SQL
2008 R2 tables.
I am unable to view as SQL if I need do some modifiction for the
table.
Is it normal that SQL Server 2008 R2 convert SQL 2000 view to a table?

No, it's not normal. Recently you were talking about BACKUP/RESTORE, but
if this happens, you must be using something else. Which you maybe
shouldn't.

[iccsi]

Post by Erland Sommarskog

Post by iccsi
I tried to move my view from SQL 2000 to SQL 2008 R2.
Once I run the scripts, I realized that my SQL 2000 views becomes SQL
2008 R2 tables.
I am unable to view as SQL if I need do some modifiction for the
table.
Is it normal that SQL Server 2008 R2 convert SQL 2000 view to a table?

No, it's not normal. Recently you were talking about BACKUP/RESTORE, but
if this happens, you must be using something else. Which you maybe
shouldn't.
--
SQL 2008:http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005:http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx

Thanks again for helping,
This is not from backup and restore which I just ran the create view
scripts from other database.
All the view becomes tables in the new SQL 2008 R2 server.
If this is the case I have to delete them and re create them to see
what happens.
All the tables in the SQL sever 2008 R2 from SQL server 2000 view has
all criteria.

Thanks millions,

iccsi,

[iccsi]

I used to import data from SQL Server 2000 including all views.
That's why SQL Sever 2008 R2 consider they are tables.
I drop view table and re create from SQL then the view still view now.
Thanks a million for helping,

iccsi

Post by Erland Sommarskog

Post by iccsi
I tried to move my view from SQL 2000 to SQL 2008 R2.
Once I run the scripts, I realized that my SQL 2000 views becomes SQL
2008 R2 tables.
I am unable to view as SQL if I need do some modifiction for the
table.
Is it normal that SQL Server 2008 R2 convert SQL 2000 view to a table?

No, it's not normal. Recently you were talking about BACKUP/RESTORE, but
if this happens, you must be using something else. Which you maybe
shouldn't.
--
SQL 2008:http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005:http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx

[Erland Sommarskog]

Post by iccsi
I used to import data from SQL Server 2000 including all views.
That's why SQL Sever 2008 R2 consider they are tables.

Yeah, those GUI things are deceivable. You don't really know what they are
up to. Although, I seem to recall that if click buttons like "Edit SQL" you
will see in advance what will happen.

[smithjhon]

iccsi wrote on 03/27/2012 15:44 ET

Post by iccsi
I tried to move my view from SQL 2000 to SQL 2008 R2
Once I run the scripts, I realized that my SQL 2000 views becomes SQ
2008 R2 tables
I am unable to view as SQL if I need do some modifiction for th
table
Is it normal that SQL Server 2008 R2 convert SQL 2000 view to a table
Are there any way to have thme in the view to modify the SQL, lin
table and criteria
Your information and help is great appreciated
Regards
iccs

I Updated!!!!!


Thank to give a answer.....