Posted by Erland Sommarskog on 09/21/06 21:36

DataPro (datapro01@yahoo.com) writes:
> 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/

There are of course situations where you want to duplicate a schema or
copy the data from one database to another.

But since you talked about future recreation, it sounded more like a
backup to me.

Note that for development you should keep all your SQL code under
version control. If you do this, there is rarely any reason to script
from the database, since the version-control system holds the truth
about the system.



--
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: Migrating data from SQL Server 6.5 to SQL Server 2005
• Prev in forum: Re: SQL server connection
• Thread view: Re: Question on System and Data Restore

[Reply to this message]