[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


Moving data from Sql Server 2000 to Sql Server 2005

Posted on 2007-08-07
Medium Priority
Last Modified: 2013-11-30
During Importing of tables from SQL 2000 DB to SQL 2005 DB, the views in the 200DB are converting to tables in 2005.

This was not happening in the DTS provided in SQL 2000.

Please help
Question by:kshakes
LVL 50

Accepted Solution

Lowfatspread earned 500 total points
ID: 19645225
pre-establish the tables in the sql2k5 database before running the import.
LVL 21

Assisted Solution

ziolko earned 500 total points
ID: 19645244
generate SQL script on SQL2K run it on SQL2K5 and then import only data


Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
This month, Experts Exchange sat down with resident SQL expert, Jim Horn, for an in-depth look into the makings of a successful career in SQL.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
Suggested Courses

873 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question