SQL Server Table and View Index
Home > IT Answers > SQL Server > SQL Server Table and View Index
Db23
230 pts.
0
Q:
SQL Server Table and View Index
SQL Server 2005, Index Scan, SQL Server 2000 migration, SQL Server 2000, SQL Server upgrades, SQL Server views, SQL Server migration
Hi,

I was wondering if migrating a database from SQLServer 2000 to 2005 using restore or detach/attach also copies the table and view index.

Thanks.
ASKED: Apr 28 2009  9:29 AM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
Randym
1410 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
Yes, everything in the database is migrated. So tables, views, indexes, stored procedures are brought in.
Anything that is stored in the system databases are not. So DTS packages, jobs, users, maintenance plans, etc are not copied over.
Last Answered: Apr 28 2009  4:26 PM GMT by Randym   1410 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



0