Copy DB from 2005 to 2000

Is there a ligitimate way to copy database (ALL objects, not just tables and
views) from SQL 2005 to SQL 2000?
Thank you for your help!You could try the instructions in this thread:
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=842225&SiteID=1
Look for a posting titled: "How to Downgrade a Database from SQL Server 2005
to SQL Server 2000"
--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"Leon Shargorodsky" <LeonShargorodsky@.discussions.microsoft.com> wrote in
message news:BE2F5E3E-BAA3-49EA-B6A7-1BB69AE581D2@.microsoft.com...
> Is there a ligitimate way to copy database (ALL objects, not just tables
> and
> views) from SQL 2005 to SQL 2000?
> Thank you for your help!|||Leon Shargorodsky wrote:
> Is there a ligitimate way to copy database (ALL objects, not just tables and
> views) from SQL 2005 to SQL 2000?
> Thank you for your help!
You can't directly "downgrade" a database from SQL2005 to SQL2000. I
think your only option is to script it all out and the run these scripts
on your SQL2000 database.
Regards
Steen Schlüter Persson
Database Administrator / System Administrator|||DTS and, possibly, BCP.
On Wed, 1 Nov 2006 14:28:02 -0800, Leon Shargorodsky
<LeonShargorodsky@.discussions.microsoft.com> wrote:
>Is there a ligitimate way to copy database (ALL objects, not just tables and
>views) from SQL 2005 to SQL 2000?
>Thank you for your help!|||bradsbulkmail@.comcast.net wrote:
> DTS and, possibly, BCP.
> On Wed, 1 Nov 2006 14:28:02 -0800, Leon Shargorodsky
> <LeonShargorodsky@.discussions.microsoft.com> wrote:
> >Is there a ligitimate way to copy database (ALL objects, not just tables and
> >views) from SQL 2005 to SQL 2000?
> >
> >Thank you for your help!
Try SSIS, BCP or Replication
Regards
Amish Shah|||You can export your database to SQL 2000 with data . SQL 2005 support this.
All tasks--> export data
"Leon Shargorodsky" <LeonShargorodsky@.discussions.microsoft.com> wrote in
message news:BE2F5E3E-BAA3-49EA-B6A7-1BB69AE581D2@.microsoft.com...
> Is there a ligitimate way to copy database (ALL objects, not just tables
> and
> views) from SQL 2005 to SQL 2000?
> Thank you for your help!|||Many people seem to mention using SSIS, but when I tried it using the
'Transfer Database task', it wouldn't let me downgrade: 'The source
connection ... must specify a SQL server with a version less than or
equal to the destination connection ... '.
Using SQL Server 2005 Replication works, though it's a bit overkill for
a one-off task.
amish wrote:
> bradsbulkmail@.comcast.net wrote:
> > DTS and, possibly, BCP.
> >
> > On Wed, 1 Nov 2006 14:28:02 -0800, Leon Shargorodsky
> > <LeonShargorodsky@.discussions.microsoft.com> wrote:
> >
> > >Is there a ligitimate way to copy database (ALL objects, not just tables and
> > >views) from SQL 2005 to SQL 2000?
> > >
> > >Thank you for your help!
> Try SSIS, BCP or Replication
> Regards
> Amish Shah|||No, you can't 'Transfer database'. But you can script out the tables, views,
stored procedures, and the data
--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"decates" <decates@.gmail.com> wrote in message
news:1164387119.010205.146340@.m7g2000cwm.googlegroups.com...
> Many people seem to mention using SSIS, but when I tried it using the
> 'Transfer Database task', it wouldn't let me downgrade: 'The source
> connection ... must specify a SQL server with a version less than or
> equal to the destination connection ... '.
> Using SQL Server 2005 Replication works, though it's a bit overkill for
> a one-off task.
> amish wrote:
>> bradsbulkmail@.comcast.net wrote:
>> > DTS and, possibly, BCP.
>> >
>> > On Wed, 1 Nov 2006 14:28:02 -0800, Leon Shargorodsky
>> > <LeonShargorodsky@.discussions.microsoft.com> wrote:
>> >
>> > >Is there a ligitimate way to copy database (ALL objects, not just
>> > >tables and
>> > >views) from SQL 2005 to SQL 2000?
>> > >
>> > >Thank you for your help!
>> Try SSIS, BCP or Replication
>> Regards
>> Amish Shah
>