Re: Saving SQL 2000 Databases in SQL 7 format

From: Mark Allison (marka_at_no.tinned.meat.mvps.org)
Date: 07/23/04


Date: Fri, 23 Jul 2004 14:31:47 +0100

Tony,

To add to Andrew's post, if you want to export data from 2000 to 7, then
you can use DTS.

--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Andrew J. Kelly wrote:
> What exactly do you mean by "Save"?  Do you want to know how to get it into
> a 7.0 db or did Hari address your issue?
> 


Relevant Pages

  • Re: SQL 2000 - Connection Error with DTS Packages
    ... After I changed all SQL Server 'Database Connection' steps in each of my DTS ... Package" option when you right click a DTS package name in ME. ...
    (microsoft.public.sqlserver.dts)
  • Re: DTS Speed Issues
    ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ... >> Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ... >> I support PASS - the definitive, ... >>> I have to let the current Import finish before I redesign the DTS ...
    (microsoft.public.sqlserver.dts)
  • Re: vb.net dataTbl can DTS read?
    ... then using ADO to read/write the data to Sql Server. ... like what DTS does with Text Files, MS Access data, etc. ... Right now I am experimenting with writing the data from ...
    (microsoft.public.sqlserver.dts)
  • Re: SQL Server DTS From Sybase
    ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.SQLDTS.com - The site for all your DTS needs. ... > DataPump is used interchangeably with the transform Data Task ergo not the> ExecuteSQL task ... >>>> I want to import data from a Sybase database via a SQL Server DTS ...
    (microsoft.public.sqlserver.dts)
  • Re: SQL Server DTS From Sybase
    ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.SQLDTS.com - The site for all your DTS needs. ... > DataPump is used interchangeably with the transform Data Task ergo not the> ExecuteSQL task ... >>>> I want to import data from a Sybase database via a SQL Server DTS ...
    (microsoft.public.sqlserver)