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!
|||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:
[vbcol=seagreen]
> DTS and, possibly, BCP.
> On Wed, 1 Nov 2006 14:28:02 -0800, Leon Shargorodsky
> <LeonShargorodsky@.discussions.microsoft.com> wrote:
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:
>
> 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.googlegro ups.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:
>