ASE and ASE
Could it be possible to take scripts from ASA and load them in an ASE Any information is welcome jean-fran�ois ASA supports a fairly large sub-set of Transact-SQL, so if you write your stored procedures and triggers in ASA using T-SQL, you should be able to create scripts that will run against both ASE and ASA. If you're planning to do this though, I would suggest developing your database schema against ASA, since everything you write in T-SQL in ASA will be supported on ASE, but the reverse is not true. Check out the section in the ASA documentation entitled "Tra...

ASE to ASE
Hi, Is anyone out there doing ASE to ASE replication using SQL remote? If you are have created your own version of the SSEXTRACT utility to set up a replicant database in ASE rather than ASA? Or does anyone know if SYBASE has created a version SSEXTRACT for use with ASE to ASE replication? Thanks in advance Doug Trainer Hi Douglas, I thought the SQL Remote Replication support in ASE11.5 was meant for a consolidate-database only (by design)! At least that was what Sybase said when they announced support for SQL Remote technology support in ASE11.5. I will be happy to...

ASA To ASE - VS
What are the differents in terms of configuring SQL Remote Between ASA to ASE and ASE To ASE ? You should start with the Help file and then ask specific questions: Data Replication with SQL Remote PART 5. Appendix APPENDIX A. Enterprise and Anywhere: Differences There are many differences, so begin there. -- David Fishburn Sybase Please only post to the newsgroup BH Ong <bhong@tm.net.my> wrote in message news:01bf4b98$33183580$7ccdc8c8@virtual-branch... > What are the differents in terms of configuring SQL Remote Between ASA to > ASE and ASE To ASE ...

Adding ASE to existing ASE-to-ASE Installation
I am using all ASE's in my SQLRemote setup. My current installation consists of a Consolidated ASE & 2 Remote ASE's. My attempt to add another Remote ASE to the existing installation consists of these steps: - Install the sqlremote system objects in the new Remote - Install the stable queues in the new Remote - Manually extract a bcp file of the shared table from the Cons server - Configure the Cons server for another subscriber - Configure the new Remote's shared table, publications, & subscriptions. - Manually b...

User database on RSSD ASE
A simple question (I hope) for the Rep Server experts. Can you see any harm in creating a small user database on the RSSD ASE? We have Rep Server and the RSSD ASE on the same box, and I want to use the Extended File Option of ASE to make an external file on this machine available to a query, but don't know if I should create another ASE (seems like overkill) to achieve this. Is it safe to have the RSSD and another db on the same server? TIA, Don Don, That's fine. -- Thanks, G.Carter Sybase Replication Server Engineering mailto:greg.carter@workmail.com ...

loading an ASE 12 database on ASE 11.9.2 ?
I've this dump of a database, dumped from an ASE 12 system. I now want to load that on on to an ASE 11.9.2 system. Is this possible and how? It would really make my replication ASE 12 -> ASE 11.9.2 easier... /T Hi, IMHO there is no work around to loading a higher version onto a lower one! Tobbe wrote: I've this dump of a database, dumped from an ASE 12 system. I now want to load that on on to an ASE 11.9.2 system. Is this possible and how? It would really make my replication ASE 12 -> ASE 11.9.2 easier... /T ...

Dump/Load (from ASE 12.5.4 to ASE 15.x) - VS.
Hi All, We are in the process of planning the upgrade of our ASE 12.5.4 dataservers to ASE 15.x. What is the most recommended way to upgrade ASE dataservers from ASE 12.5.4 to ASE 15.x? Potential options: 1) Install new instances of ASE 15.x and load database dumps from our ASE 12.5.4 dataservers to the newly installed ASE 15.x dataservers. - OR - 2) Use the ASE upgrade utility (sqlupgrade) to upgrade our existing ASE 12.5.4 dataservers to ASE 15.x. What are the Pros vs. Cons for loading a 12.5.4 database into a 15.x ASE dataserver versus performing an ASE dataserv...

Loading a 32bit-ASE Database Dump in 64bit ASE and vice versa?
Hi, is it possible to load database dump from a 32bit ASE 12.5 into a 64bit ASE 12.5 and vice versa? Thank you for your help in advance. Best Regards, Marco Stroech ______________________________________________________ Marco Stroech Databases AOL Deutschland � Millerntorplatz 1 � 20359 Hamburg � Germany +49 (40) 36159-7454 � fax: +49 (40) 36159-7460 voice/fax@aol: +49 (40) 3603-444444 mstroech@aol.com Marco Stroech wrote: > is it possible to load database dump from a 32bit ASE 12.5 into a 64bit ASE > 12.5 and vice versa? You can go from the 32bit vers...

Download Database from ASE 11.9.2 to ASE 11.0.2 ?
Dear All: We have a Sybase ASE11.9.2 on Window NT, and we already run some application on it about 6 months. Since the third party software we use cann't support ASE11.9.2, we must use ASE 11.0.2. Can we just backup the database of ASE11.9.2 then restore the backup database to ASE11.0.2 ? Has it any problem ? Or, We must do following procedure. 1) bcp out the data from ASE11.9.2 2) create the database on ASE11.0.2 3) bcp in the 1) data to ASE11.0.2 Can anyone tell me?? Teresa Young Teresa, The problem with dump and load is that the log format in 11.9.2 is much diff...

Transferring database ASE 11.9.2 -> ASE 11.5
Hello, I need to transfer a database from a ASE 11.9.2 server to a ASE 11.5 server. (Servers have the same specs and run Windows NT 4.0). The database doesn't have many objects such as tables, users, Views, SP's etc. etc. It has a 400 MB device for data and 100 MB Device for the log, with standard segmentation. It's relatively small. I understand from this newsgroup that dumping on a newer release and loading on an older release is not an option. Now I figure I have to do the following: - Create a data and a log device with similar names and sizes on the ASE 11.5 se...

Fail to online database(ASE 12.5->ASE 15.0 developer)
Hi Everyone, Could you please help me to take a look at the error? It happened when I want to online databse, I can load database successfully:-), but failed to online...... I backup up the database from ASE 12.5, and restore it to ASE 15.0 developer... 1> online database AdventureWorksDW 2> go Started estimating recovery log boundaries for database 'AdventureWorksDW'. Database 'AdventureWorksDW', checkpoint=(15436, 11), first=(15436, 11), last=(15436, 11). Completed estimating recovery log boundaries for database 'AdventureWorksDW'. Started ANA...

Can we restore a database on ASE 11.0.3 which was on ASE 11.0.2 ?
Hi, I did a backup of a database which was on ASE 11.0.2. Can we restore it without any problems on ASE 11.0.3 ? Thanks very much. -- Have a nice day. Raphael Lignier Escalation Support Engineer ASCEND COMMUNICATIONS GIS - Sophia-Antipolis On Wed, 31 Mar 1999 15:02:30 -0800, Raphael Lignier <rlignier@ascend.com> wrote: >Hi, > >I did a backup of a database which was on ASE 11.0.2. > >Can we restore it without any problems on ASE 11.0.3 ? Yes, dumps are upward compatible (that is: you can load older dumps on newer servers). When conversion...

sql-remote between ASE and ASE
hello! sql-remote document don't give us help with replication with ASE and ASE. i need detail how to do it. i use ASE12 + NT4.0 + SQL Remote6.0.2 . i test it in the list 1�� define messagetype : smtp 2�� define use_name :one is publisher,the other is remote user_name 3�� define publisher,publication,subscription 4��execute ssremote.exe to receive or send message I failed at the step of extract database .i don't extract the database . please help me ,tell me the datail of sql-remote confige. Thanks a lot , ...

ASE workgroup
hi, what the diference between ASE workgroup and ASE Enterprise, to which systems apply workgroup or enterprise. is an AlphaServer 4000 (DIGITAL SERVER 7305) workgroup and unix and ASE 12.0 will be avaliable for true unix (DEC UNIX). thanks in advance ...