We are using Sybase 8 and Sybase 16 databases in our current project. I have a requirement where I need to script the a complete Sybase database(with some built-in data in certain tables) with Sybase scripting tools. For example, if I run a Sybase script, it would create a Sybase database for me. I tried using the combination of Dbunload (to create a dump), dbinit (to create a new db) and dbisql (to add data to database) commands but am not able to get at it. Require help regarding this from any Sybase db administrator in this forum.Thanks.
Script the a complete Sybase database
949 Views Asked by MgmtTech At
1
There are 1 best solutions below
Related Questions in SYBASE
- Alternative to Top 1 in Sybase DB
- Rounding/conversion of Number/decimal in Sybase IQ
- Connect to Sybase IQ server using Python script on Mac M2
- how to check like condition in if loop
- How can i use a select statement inside another select query statement?
- How to add two sql column decimal values in normal select query
- count(Distinct) windowing function alternative
- Could not load file or assembly 'Sybase.AdoNet2.AseCient'
- Mybatis return -1 when insert and update query execute
- Sybase IQ datepart function strange behaviour
- The type initializer for 'Sybase.Data.AseClient1.AseConnection' threw an exception. SSIS - Sybase
- Sybase jTDS vs jconnect driver
- Azure Data Factory | Sybase database | Error While pulling Data
- Sybase isql : An error occurred when attempting to allocate localization-related structures
- Sybase ASE connetionString is not working without userName/Password
Related Questions in SYBASE-ASA
- sybase model database is unavailable
- Unable to connect to the SYBASE Database in Docker when triggered through FASTAPI
- What does adding a comma and a number mean in a Sybase SQL where expression?
- Sybase Database Support on Node.js with SSL
- sybase escape character
- Replication from Sybase SQL Anywhere to MSSQL
- How to pass TEXT(the list of id's as a string) to sybase ase stored procedure
- Sybase ASA sequence
- I need to do a query from 2 tables using count function
- SQL Unique ID for union all - Sybase
- How to return greater value of the period for unique id combination?
- Sybase identity_gap attribute is not maintaining specified gap
- Update record with case statement for Sybase ASA11
- Show record data in the last 1 hour in sybase ASA11
- Create Trigger for Update with condition in Sybase ASA16
Related Questions in MYSQLADMIN
- MYSQL where to set password for mysqladmin?
- Wordpress plugin development and Gitlab pipeline Mysql service error
- mariadb state wise where case clause inside view
- Is there a tool to show schema/definition changes between two dump files for MySQL?
- Checking when a MySQL server is ready to run queries without interrupting them
- Is there a way to change MySQL root password during re-installation (Windows 10)?
- BLOB/TEXT column 'bought_furniture' can't have a default value
- Using Roles in MySQL Azure - Privileges Issues on Admin Account
- MySql Admin User lost Privileges
- rows missing in mysql
- How to debug "ER_HOST_IS_BLOCKED: Host 'abc' is blocked because of many connection errors" error
- creating MySQL Trigger to insert into second table
- mysqladmin Access Denied when using -defaults-file=/etc/mysql/debian.cnf
- MySQL table listed twice with different case name
- Cannot set password for MySQL root user
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Popular # Hahtags
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
If you want to use a complete tool to generate the DDLs then you can use PowerDesigner for example.
If you want to write your own scripts in T-SQL or Watcom SQL what create the DDL scripts then you can also do this. All information about table schema is available in system tables. The full description of columns is also available in the documentation of SQL Anywhere.