Browse By Category

June 26, 2002 08:26 PM

Migrating a SQL Server 2000 Database to SQL Server 7.0

Rating:

(0)

Microsoft's SQL Server Development Team

SQL Server Magazine

InstantDoc ID #25298

I need to migrate my SQL Server 2000 database for use on a SQL Server 7.0 database. I haven't used any SQL Server 2000-specific features. What's the best way to move this database back to SQL Server 7.0?

You can migrate the database in three ways, depending on the volume of data involved and how often you will perform this move. If you have small amounts of data, you can set up a linked server (SQL Server 7.0 linked to SQL Server 2000). On the SQL Server 7.0 machine, use SELECT...

...This article is for paid Professional Members only.

Already a Professional Member? Please log in now:

Professional Membership

Monthly

Annual

Monthly

Annual

Compare Member Benefits

Add a Comment

There are no comments to display. Be the first one!

You must log on before posting a comment.

Are you a new visitor? Register Here

Control statements

I am trying to print a message based on the value of a variable. I have tried: IF @DEMOCNT = 0 PRINT 'Pass' ELSE PRINT 'Fail' I hav...

More Posts

Changing SSIS and SSRS service accounts
IP and MAC addresses
Job categories

Essential Guides

Choose the Right Storage Architecture for your SQL Server Environment | Overwhelmed by the many different storage platforms available in today’s SQL Server market? Wendy Henry discusses how choosing the right storage for your environment does not have to be a confusing process.

Web Seminars

Database Schemas: Getting it Right the First Time | Database modeling and design are at the core of a healthy database management and performance foundation. Getting it right the first time will enhance the bottom line in a variety of ways.View this on demand web seminar

eBooks

Playbook for a Virtualized Datacenter | Organizations are looking to extend virtualization to encompass the entire datacenter. This playbook provides you with a step-by-step overview of the benefits, challenges, technology options and best practices for datacenter virtualization.

eLearning Series

Windows IT Pro brings the experts direct to you to share their real-world perspective, experience, and expertise. During each event, three sessions stream in real time, allowing you to learn, to ask questions, and to get solutions.
Upcoming event: SQL Server Consolidation

© 2010 Penton Media, Inc.

Windows is a trademark of the Microsoft group of companies. Windows IT Pro is used by Penton Media Inc. under license from owner.