on 2018 Nov 12 5:40 AM
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
Request clarification before answering.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
33 | |
22 | |
17 | |
8 | |
5 | |
5 | |
4 | |
4 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.