Can I use SQL DB Publishing Wizard to transfer from SQL200..

I have a DB that was put on a temporary server, which has SQL2005. I need to
transfer the DB back, but the original server is SQL2000 SP2. I found a
posting on another forum / newsgroup that seems to indicate that the
Microsoft SQL Server Database Publishing Wizard might work for this. I
realize that the SQL 2000 is behind a few service packs, and would likely
need to be updated, as well, this is not an issue.

Basicly, my question is, will this work? Will I be able to run this
utility, to move the DB, its associated views, etc, back to the SQL 2000
server?

Thank you,
Jason A.

Jason A Ash (JasonAAsh@discussions.microsoft.com) writes:
> I have a DB that was put on a temporary server, which has SQL2005. I
> need to transfer the DB back, but the original server is SQL2000 SP2. I
> found a posting on another forum / newsgroup that seems to indicate that
> the Microsoft SQL Server Database Publishing Wizard might work for this.
> I realize that the SQL 2000 is behind a few service packs, and would
> likely need to be updated, as well, this is not an issue.
>
> Basicly, my question is, will this work? Will I be able to run this
> utility, to move the DB, its associated views, etc, back to the SQL 2000
> server?

I believe the Publishing wizard has an SQL 2000 mode, in which case
you should be fine, as long as you are not using features new in SQL 2005.

--
Erland Sommarskog, SQL Server MVP, esquel RemoveThis @sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx