Posted by DataPro on 09/21/06 13:41

In DB2, to save off data and structure we use utilties db2look and
db2export.

I can see that in SQL Server that I can script (ddl) the objects and
relationships and export the data. Its, I believe a matter of
redundancy more than anything else/

Thanks


Erland Sommarskog wrote:
> 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: Question on moving logs
• Prev in forum: Re: UNION / INTERSECT / EXCEPT in SQL Server 2000
• Thread view: Re: Question on System and Data Restore

[Reply to this message]