printmedia
asked on
Move database from SQL Server 2000 to 2008
Hi all.
I have 3 databases that I want to move from SQL Server 2000 to another box which has SQL Server 2008. What is the best way to do this?
I was thinking making a backup of each database on SQL Server 2000 and then going to SQL Server 2008 and restoring those files. Is that possible?
Thank you in advance!
I have 3 databases that I want to move from SQL Server 2000 to another box which has SQL Server 2008. What is the best way to do this?
I was thinking making a backup of each database on SQL Server 2000 and then going to SQL Server 2008 and restoring those files. Is that possible?
Thank you in advance!
Last Comment
SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
The quickest way would be to create a new view of the existing view on SQL Server 2008 and point to the same tables on SQL Server 2008. (Just open the old view (Design) and copy all the text and copy that over to the new view).
SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
One other thing to add to Jose Torres' comment:
If your existing tables have a text datatype, you may receive errors querying against the newly created table.
If your existing tables have a text datatype, you may receive errors querying against the newly created table.
Microsoft SQL Server
Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.
171K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
ASKER
That being said, since the views will still be on SQL Server 2000, will these views be able to look at the tables on SQL Server 2008? What would I need to change in the views to be able to look at the tables on SQL Server 2008?