on 2014 Mar 13 11:29 AM
Hi, I just want to ask some help I am using SQLAnywhere 9,I have 80 tables in my database and already have thousand of data,..Now I want to create a reset database and i want to have the same table structure.,or Is it possible to extract the table structure of my database so that i can create a reset database with an empty tables?
please help me.
Thank you in advance.
Request clarification before answering.
Use dbunload to export your schema. Example:
dbunload -n -c connection-string-to-your-database
This will generate a reload.sql file that you can then use to regenerate your schema in a new dbinit'ed database.
HTH
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
77 | |
30 | |
10 | |
8 | |
8 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.