Home
Topics
Microsoft SQL Server Administration
SQL Server Backup and Recovery
SQL Server 7.0 database creation using DTS or BCP

SQL Server 7.0 database creation using DTS or BCP

Greg Robidoux, Founder, Principal Database Engineer, Edgewood Solutions

I currently use SQL Server 2000 but my client uses SQL Server 7.0. We need to give them a database that SQL Server 7 can restore onto its system. Can we do this? Is there any way we can convert the .BAK file?

Requires Free Membership to View

Login

By submitting your registration information to SearchSQLServer.com you agree to receive email communications from TechTarget and TechTarget partners. We encourage you to read our Privacy Policy which contains important disclosures about how we collect and use your registration and other information. If you reside outside of the United States, by submitting this registration information you consent to having your personal data transferred to and processed in the United States. Your use of SearchSQLServer.com is governed by our Terms of Use. You may contact us at [email protected].

You can not restore a SQL 2000 database back to a SQL 7.0 format.

The only way to create a SQL 7.0 database would be to recreate all of the database objects on a SQL 7.0 server and then import all of the data. This can be done using DTS or BCP.

Do you have comments on this Ask the Expert Q&A;? Let us know.

More News and Tutorials

Articles

Related glossary terms

Terms for Whatis.com - the technology online dictionary
- database replication
- rollback

This was first published in July 2005

Join the conversationComment

Share

Comments

Results

Contribute to the conversation

All fields are required. Comments will appear at the bottom of the article.

Back to top

More from Related TechTarget Sites

Business Analytics
Data Center
Data Management
Data Management UK
Oracle
Content Management
Windows Server

Business Analytics
- Analytics in the cloud drives culture and pricing changes
  
  One company's pursuit of low-cost cloud computing had a surprising impact on how it sold analytics services.
- Geospatial data could transform the way government does business
  
  With the help of geospatial data and visualization techniques, government can make decisions for constituents that are smarter and have more impact.
- Mobile BI apps move up the corporate priority list
  
  The growing use of tablet PCs and smartphones is spurring demand for mobile business intelligence capabilities from end users. Are you ready?
Data Center
- An in-depth look at IBM's transactional memory support facility
  
  IBM's zEC12 mainframe introduced support for transactional memory. Learn the basics of Transaction Execution Facility.
- Introducing the software-defined data center
  
  The software-defined data center is here to stay, but what does that mean for IT pros?
- Five examples of doublespeak from cutting edge technology vendors
  
  The terms used by vendors to describe cutting edge technology are often colorful. Here are five examples and the truth behind the tech.
Data Management
- Effective 'big data' strategy helps advertising firm attract clients
  
  Online advertising company adMarketplace uses a mix of NoSQL and SQL databases in a "big data" environment that feeds its search syndication system.
- IBM executives, customers share 'big data' tips at Information on Demand
  
  An IBM VP and a user from Sprint took to the stage at the vendor's Information on Demand conference to offer advice on how to make sense of big data.
- Zornes connects the dots between big data and master data management
  
  Consultant Aaron Zornes believes that MDM and big data were made for one another.
DataManagement UK
- Big data roundtable webcast: gaining value from big data
  
  Roundtable discussion on business value of big data, chaired by Brian McKenna, Editor, SearchDataManagementUK, and featuring Mike Ferguson, Roxane Edjlali (Gartner), Joshua LeCure (GlaxoSmithKline).
- 2012 training courses: BI, data management, data warehousing
  
  Find out where to hone your business intelligence, data management and data warehouse skills with this list of training courses for 2012.
- Poor data quality: what is dirty data costing UK organisations?
  
  Poor data quality can have serious financial consequences for businesses. Read about the current state of data quality management at UK companies, including dirty data problems.
Oracle
- Using SQL SELECT and SQL UNION ALL statements to sort numbers
  
  Expert Dan Clamage explains how to use SQL SELECT and SQL UNION ALL statements to sort and visualize a set of sales figures.
- Oracle Solaris 11.1 update focuses on database integration, cloud
  
  The Oracle Solaris 11.1 operating system update is keyed in on integration with Oracle Database and cloud computing features.
- Oracle E-Business Suite R12 upgrade aided by checklists
  
  A pre- and post-upgrade checklist will go a long way toward ensuring a successful Oracle E-Business Suite R12 upgrade.
Content Management
- Successful social collaboration efforts have common key facets
  
  Three examples of companies that have taken different routes to implementing enterprise social collaboration demonstrate that they share similarities that might explain their success.
- Personal privacy an issue in enterprise social plans at multinationals
  
  Different cultures view personal privacy matters differently. Multinationals wanting improved collaboration must plan enterprise social networks adoption carefully.
- Three questions bring focus to document imaging, management planning
  
  Asking three questions about organizational needs helps map out an effective document management and imaging process, says IT consultant Steve Weissman.
Windows Server
- FAQ: troubleshooting common errors in Microsoft PowerShell
  
  In this FAQ, we have our resident PowerShell expert answer some common questions to help admins troubleshoot errors in this scripting language.
- Shared-nothing live migration increases high availability
  
  Admins have the option to get shared-nothing live migration. Here's what you need to know about the move, including tradeoffs you should be aware of.
- Microsoft signals 'Cloud OS' ambitions with Windows Server 2012
  
  With Windows Server 2012 out, Microsoft solidified its position as a cloud-oriented company. Experts wonder if the move will resonate with customers.

All Rights Reserved,Copyright 2005 - 2012, TechTarget