How do I copy the schema of an existing database into a brand new database without copying the data ? (so not dbunload -an ) Thanks Mark asked 12 Nov '18, 05:40 ThelmaCottage |
You want -n "Does not unload database data; reload.sql contains SQL statements to build the structure of the database only. If you want the reload.sql file to contain LOAD TABLE or INPUT statements, use -nl instead. " Then create a new database, connect to it and run the reload.sql script. http://dcx.sybase.com/index.html#sa160/en/dbadmin/dbunload.html BTW it's always worth saying which version of SQLA you are running. answered 12 Nov '18, 07:26 Justin Willey Just to add: The initial section of the "reload.sql" file contains a comment with an according CREATE DATABASE statement you can use to build the new database with appropriate settings for page size, collations and the like.
(12 Nov '18, 07:36)
Volker Barth
|