Are there any good database schema comparison tools out there that support Sybase SQL Anywhere version 10? I've seen a litany of them for SQL Server, a few for MySQL and Oracle, but nothing that supports SQL Anywhere correctly. I tried using DB Solo, but it turned all my non-unique indexes into unique ones, and I didn't see any optio...
Well, the question is pretty much in the title. I've just installed Visual Studio SP1, and now when I want to import a Entity Model from a database, it doesn't display the SQL Anywhere provider anymore. Does anyone know if there is a patch or some way to make it work with SP1? Thanks. ...
I have a SQL script that I want to output progress messages as it runs. Having it output messages between SQL statements is easy, however I have some very long running INSERT INTO SELECTs. Is there a way to have a select statement output messages as it goes, for example after every 1000 rows, or every 5 seconds? Note: This is for SQL An...
Hi All, I have sproc 'up_selfassessform_view' which has the following parameters: in ai_eqidentkey SYSKEY in ai_acidentkey SYSKEY out as_eqcomments TEXT_STRING out as_acexplanation TEXT_STRING - which are domain objects - SYSKEY is 'integer' and TEXT_STRING is 'long varchar'. I can call the sproc fine from iSQL using the following...
Scenario: Our install package used to add User DSN. We changed this to install System DSNs due to Terminal Servers and Citrix. The problem is that some of these old User DSNs are floating around, and our application automatically chooses the User before the System and the connection info has changed as we upgraded server software. I g...
I just downloaded the developer edition of SQL Anywhere. How can I get a list of tables in the database I'm connected to?. Also for a particular table, how do I get the meta-data for that table (column names, types, etc)? ...
I have a user-defined SQL function that returns 1 or 0 and I want to call it from a column CHECK constraint. ...
I want to write a SQL IF statement that checks whether or not a local temporary table exists, but those kinds of tables are not recorded in the SQL Anywhere system catalog. ...
Disclaimer: This is an "asked-and-answered question" posted in accordance with the FAQ statement that it's "perfectly fine to ask and answer your own programming question". Its purpose is to encourage members of the SQL Anywhere programming community to use StackOverflow by seeding the "sqlanywhere" tag with some real-world content. Edit...
I've got a SQL Anywhere 9 database, and I would like to reset the autoincrement value on one of my columns to a specific number. I guess I need the SQL-Anywhere equivalent of: ALTER TABLE foo AUTO_INCREMENT =100 ...
Here is the scenario. I have an Oracle consolidated database. I am using Mobilink to synchronize Oracle with a SqlAnywere database that is being used on a handheld. If userA changes a record in the remote DB on their handheld device to "updated first" and then 10 minutes later userB updates the same record on their handheld device to ...
A general question. I am developing for Sybase SQL Anywhere 10. For backwards comptibility reasons, almost all our Stored procedures are written in Transact-SQL. Are there any advantages or disadvantages to using T-SQL instead of the Watcom dialect? ...
I have been playing with the EF in the last couple of days. Our applications are based on SQL Anywhere 10 databases, and all our data access are done through stored procedures. Since EF is not supported by SA 10, I am testing EF with SA 11. For this purpose i have create a small database with 2 tables and a couple of stored procedures (b...
I have a bat file that I am using to try and register Mobilink with the Mobile Device Center on Vista. (I am using version 11 of Mobilink) Script: mlasinst -k ./ -v ./ I have copied mlasinst as well as mlasdev.dll and mlasdesk.dll to the same folder and am running the above command to get the sychronization process to run.(I have test...
Hi, I have a below block of code calling from c language. do_connect(); db_find_engine(&sqlca,NULL); //EXEC SQL CONNECT "athena" IDENTIFIED BY "amci"; dbpp_connect_40( (sqlcaptr), &__SQLV_sql_1, __SQLV_sql_2, __SQLV_sql_3, SQLNULL, SQLNULL, SQLNULL ); I am getting below mentioned crash at the above line of code(dbpp_connect_40). I a...
Hello all, The context : My current project uses VistaDB as it really fits the main scenario: the user log into the application, selects the DB (file on HDD or Network drive), does his job, then logs off. The DB (a single file) can be copied (email, usb dongle, cd ...) and transfered to colleagues or to the headquarters. And, best of al...
What tools can I use to monitor performance, defragment, etc. a Sybase SQL Anywhere database? ...
I have found a lot of topics about stress-testing web application. My goals are different, it's to test only database (sybase sql anywhere 9). What I need: Some tool to give a diagnostic of all sqls and find a bottleneck. I wish I could macro-view the entire system easily. Best practices to design/build a good sql queries. The syst...
Hi, I would like use PHP PDO with SqlAnywhere, but don't have the driver on php site. Can I add a lib of sqlanywhere to use with PDO? ODBC is the last option. ...
I'm storing .NET TimeSpan objects in a SQL Anywhere database as their underlying .NET implementation type, a 64-bit integer. I've even created a custom domain called "timespan" to do so. When debugging in Visual Studio, you can override the default ToString() for the debugger window so that it shows what you want. I'm looking for a si...