Posted by Erland Sommarskog on 09/20/06 21:29

DataPro (datapro01@yahoo.com) writes:
> new to SQL Server 2000. We have an obsolete database that we need to
> save off for x number of years. DB2 has utilities (DB2Look/Export)
> that allows for the export of the data along with a schema and script
> that enables the future recreation of the structure of the databases
> and tables to include RI etc. You can save off the architecture and
> relationships of the tables as well as the data.
>
> Does SQL Server have anything similar?

I don't see why you would anything else than a normal database backup?


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

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Re: Character set support
• Prev in forum: Re: cursor to compare/report on the same fields in 2 tables
• Thread view: Re: Question on System and Data Restore

[Reply to this message]