Re: Downgrade from SQL Server 2005 to 2000

You'll have to script out your objects and run the scripts in the SQL 2000
DB, then load your data. You can do this with a DTS or SSIS package (Copy
Database).

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada

"DJFunkenstien" <DJFunkenstien@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:4AD295E5-84CA-484D-97C9-4B0F3A85EE70@xxxxxxxxxxxxxxxx
Hey Folks,

As above, any ideas how to DOWNGRADE -- from SQL Server 2005 db to 2000?

I'd appreciate any cool ideas. Thanks ahead

--
Cheers!

Jonathan A. Conway


.

Relevant Pages

  • Re: DTSRun and Batch file
    ... >> install the DTS DLLs on the local machine. ... So the DTS package is running ... >> user to start a SQL Agent Job that runs the package. ... Darren Green (SQL Server MVP) ...
    (microsoft.public.sqlserver.dts)
  • Re: How do I run a .BAS file saved from a DTS package?
    ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ... I have used DTS for import and export. ... > The DTS Designer is easy to understand and use. ...
    (microsoft.public.sqlserver.dts)
  • Re: ActiveX script works in DTS but not in job, why?
    ... Peter DeBetta, MVP - SQL Server ... As another test I saved the script as a .vbs file and tried running it, ... Microsoft OLE DB Provider for SQL Server ... 2000 databases including DTS packages. ...
    (microsoft.public.sqlserver.dts)
  • Re: Pls Help -- Upsizing from Access
    ... DTS is very nice btw. ... Jim ... work in SQL Server. ...
    (microsoft.public.sqlserver.programming)
  • Re: Using global variable in DTS packages
    ... Global Variables and SQL statements in DTS ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.SQLDTS.com - The site for all your DTS needs. ...
    (microsoft.public.sqlserver.dts)