General Question about Publications and Reference Databases

I have an ASA database and I will synch it with an UL.NET database.  The 
consolidated database already exists and the UL database will be new.

I use UL Schema painter to create the USM file and I control the 
synchronization by wrting SQL in the upload/download events of the 
consolidated db.

So it appears that I do not need either a reference database or any 
publications.  Is this true?  What then is the purpose of using a reference 
database and/or publication?  Is it just an alternate way to achieve the 
same end?  Or am I missing something?

rr12


0
rr12
9/26/2005 6:53:48 PM
sybase.sqlanywhere.mobilink 5254 articles. 0 followers. Follow

1 Replies
435 Views

Similar Articles

[PageSpeed] 44

"rr12" <abc@123.com> wrote in news:433843bc$1@forums-1-dub of
sybase.public.sqlanywhere.mobilink: 

rr12> So it appears that I do not need either a reference database or any 
rr12> publications.  Is this true?  

Yes, quite true.  Although, didn't you create a publication in the
schema painter to indicate which tables you want to synchronize?

Perhaps the default was "all".


rr12> What then is the purpose of using a reference database and/or
rr12> publication?  Is it just an alternate way to achieve the same end?
rr12> Or am I missing something?

Flexibility.
I like using Sybase PowerDesigner for creating my data model.
Then I can target the creation of an ASA database.
Using ULINIT, I can create a USM for the UltraLite schema.

This is the model I use.

-- 
David Fishburn
Certified ASA Developer Version 8
iAnywhere Solutions - Sybase 
Professional Services
Please only post to the newsgroup
Please ALWAYS include version and MORE importantly BUILD number with 
EACH post (dbeng9 -v).

EBFs and Maintenance Releases
http://downloads.sybase.com/swx/sdmain.stm 

Developer Community / Whitepapers
http://www.ianywhere.com/developer

CaseXpress - to report bugs
http://casexpress.sybase.com

CodeXchange - Free samples
http://ianywhere.codexchange.sybase.com/servlets/ProjectDocumentList

0
David
9/26/2005 7:56:17 PM
Reply:

Similar Artilces:

[PATCH] GNU Public General Public General GNU Public License License
--- pod/perlgpl.pod 2003/08/13 18:07:09 1.1 +++ pod/perlgpl.pod 2003/08/13 18:07:14 @@ -1,7 +1,7 @@ =head1 NAME -perlgpl -- the GNU Public General Public License, version 2 +perlgpl - the GNU General Public License, version 2 =head1 SYNOPSIS --- pod/perlartistic.pod 2003/08/13 18:07:30 1.1 +++ pod/perlartistic.pod 2003/08/13 18:07:31 @@ -1,7 +1,7 @@ =head1 NAME -perlartistic -- the Perl Artistic License +perlartistic - the Perl Artistic License =head1 SYNOPSIS -- Michael G Schwern schwern@pobox.com http://www.pobox.com/~schwern/ It'...

Mobilink Reference Database.
Does the Reference database need to be created on the same server as the Consolidated database? And do the system tables need to be installed on the Reference database as well? The reference database MUST be an ASA database. Therefore, those tables already exist. No it does not need to be installed on the same machine as the consolidated. Consider this situation. 1. Your enterprise database is Oracle (bad choice I know) 2. There is only 1 enterprise database server locked up in a heavily air conditioned room. 3. You are using a laptop to develop your application. 4. You ha...

General Database Design Question
I have a table that will probably have 250+ fields - one business entity with 250+ attributes. I was wondering from a design, performance, and administration point of view if I would be better off splitting this table into smaller tables by grouping the logical work units... Meaning... Option (1) tdtALL - 250+ fields Contains all the entity information Option (2) tdtMAIN - 45 Fields Contains main entity information tdtLUW1 - 20 Fields Contains logical unit of work 1 (1 to 1) tdtLUW2 - 40 Fields Contains logical unit of work 2 (1 to 1) tdtLUW... Any comments regarding eith...

General Database Design Question
Okay, I have my idea of how to do this, but would like to get experience's idea of how to do this since I am a mere 3.5 weeks into using SQL.I am working on a time off tracker for my company. We have an employee table (employee), a request table(request). Originally I was told that all vacation is a lump of days and they take time off and it is subtracted from their vacation time. Now, I am getting told they can take off vacation, pto, bereavement and possibly more. I have a time off table now (time_off) that I made just so I could add time off types for tracking what time of t...

General beginner questions about databases.
does any1 have a good guide which explains all the expressions related to databases?with PHP i used MYsql and with ASP.NET i use SQLserver. that's all i know.but there are always expressions which i don't understand such as ADO.NET, ADBO , SqlDataSource, objectdatasource and more.By the way, if i take a database created with Mysql, will i be able to use it with Sqlserver and vise versa? thx.  Hi, The ASP.Net you can use any database not just SQL server, you can use Oracle, Access, XML or any other ODBC and ofcourse MySql, you could connect to it using ODBC or the MySql.net ...

Mobilink / PocketBuilder Question -- Remote Database
I was going through the PocketBuilder tutorial and more specifically, was reading through the sql that creates the remote database. If the consolidated database has a table with 100 columns, does the remote version of it need to have all 100? Or does the remote table you want to work with simply need the primary key and the columns that you want to update? Thanks, Tom Yes, if you are using MobiLink you can choose as many or as few columns as you like (as long as the Primary Key exists in the remote table). -- Liam Cavanagh Sr. Product Manager Certified ASA Developer Ver...

Mobilink Custom Authentication ( General question )
Consolidated Database ASA 8.x , 9.x Ultralite palm and pocket pc clients In our Desktop system users are created as Database users ( ASA ) .And the user/password are directly mapped to Mobilink users and password . Now when we do authentication in authenticate_user script I want to check against ASA username and password ( SYSUSERPERM ) . AFAIK there is know way to check the pssword with out making a connection . And looks like CONNECT statement is not supported in functions and procs. If we write .NET code is it advisable to make a DATABASE connection with the username...

general question for ASP and SQL database
Hi everyone, I've wrote a ASPX page that reads data from my SQL database. The SQL database reside in virtual window server 2003 that has put on the company's network. Everything works fine when the virtual server is on company's network. And now I unjoined the virtual server from the network and ASPX page doesn't work anymore. It seems because it can not get data from SQL server. Is there ways to make ASPX and my SQL server work fine without putting the server on the company's network? Should I setup a physical server and put SQL ser...

general database (I think) join question
Hi, I've been given an Excel form to 'emulate' on screen that uses 1 grid to display the results from three different tables. One is a FoxPro table, and the other two are newly created tables(MySQL). I've never done this before so I'd like some advice/help on this. Given the following: H1 H2 H3 H4 H5 H6 H7 H8 H9 H10 H11 H12 H13 H14 H0 is present in the FoxPro and MySQL tables (but is not displayed). H1 to H6(except H2) from FoxPro table H7 & H8 from MySQL table H2, H9 to H14 from another MySQL table. Now norm...

a General database question. Please help urgent!
guys i have a programming question i have table called prerequsiteswhich is like thisprerequisite component                       componenta                                                         bso in...

borland.public.delphi.database.general not fond
Hello. My problem is I am trying to connect to a newsgroup that I have configured in Outlook Express 6, under Windows XP and appears this as follows mistake : 411 Group borland.public.delphi.database.general not found. Setup: Count: newsgroups.borland.com Server: newsgroups.borland.com Protocol: NNTP Port: 119 Security (SSL): 0 Error Number: 411 Code: 800ccca5 With the newsgroup of Newsgroups.borland.com before it could enter the group borland.public.delphi.database.general, This is for all groups that begin with borland. I hope you can hel...

publication question
We are running ASA 6.03.3030. I am curious how the Message Agent handles this situation: We have a publication with one table (customer table). Customer table consists of two columns, company and customer. Each subscriber subscribes by company. For example, we will have remote_1 subscribed by company 1 and remote_2 subscribed by company 2. If a customer changes companies, how does the message agent handle this. For instance, on the consolidated someone issues the following statement: UPDATE customer SET company = 2 WHERE company = 1 AND customer = 90...

which database does the database refer in "Not connected to a database" of the second paragraph
I. 01/01 02:30:40. Synchronization Started I. 01/01 02:30:40. Adaptive Server Anywhere MobiLink Synchronization Version 8.0.2.4258 I. 01/01 02:30:40. I. 01/01 02:30:40. Copyright _ 1989-2002 Sybase, Inc. Portions Copyright _ 2002, iAnywhere Solutions, Inc. I. 01/01 02:30:40. All rights reserved. All unpublished rights reserved. I. 01/01 02:30:40. I. 01/01 02:30:40. This software contains confidential and trade secret information of I. 01/01 02:30:40. iAnywhere Solutions, Inc. Use, duplication or disclosure of the software and documentation I. ...

borland.public.delphi.database.general not fond #2
Hello. My problem is I am trying to connect to a newsgroup that I have configured in Outlook Express 6, under Windows XP and appears this as follows mistake : 411 Group borland.public.delphi.database.general not found. Setup: Count: newsgroups.borland.com Server: newsgroups.borland.com Protocol: NNTP Port: 119 Security (SSL): 0 Error Number: 411 Code: 800ccca5 With the newsgroup of Newsgroups.borland.com before it could enter the group borland.public.delphi.database.general, This is for all groups that begin with borland. I hope you can hel...

Web resources about - General Question about Publications and Reference Databases - sybase.sqlanywhere.mobilink

Publication - Wikipedia, the free encyclopedia
... images, or other audio-visual content on any traditional medium, including paper ( newspapers , magazines , catalogs , etc.). The word publication ...

Academic publications to become less important when funding university research
The Turnbull government is set to overhaul the way university research is funded by dramatically downgrading the importance of publishing articles ...

Academic publications to become less important when funding university research
The Turnbull government is set to overhaul the way university research is funded by dramatically downgrading the importance of publishing articles ...

Do You Share Your Law Firm’s Publications On Facebook?
Facebook represents an increasingly important method of distributing your legal publications.

ESPN 'Suspends Publication' of Grantland, Five Months After Showing Bill Simmons the Door
ESPN is "suspending" the publication of Grantland, the writerly sports-and-pop-culture site founded for the company in 2011 by Bill Simmons, ...

CBS Outdoor Name Change Is Trouble for Denver LGBT Publication
When CBS Outdoor last fall spun off as Outfront Media Inc., it immediately caused problems for Denver-based LGBT publication Out Front magazine ...

ESPN is suspending the publication of Grantland
... a bombshell on Friday. After weeks and months of speculation regarding its future, the network announced that it was suspending the publication ...

Schrodinger’s iPhone 6s sales: Publication claims Apple will both break and miss sales record
Apple sold more than 13 million iPhone 6s and iPhone 6s Plus units during their debut weekend , and the company is preparing to launch the device ...

ESPN Announces It Has Suspended Publication of Grantland - Bleacher Report
After four years of publication, Grantland is no more, as ESPN announced the sports and pop culture blog will be shuttered immediately...

"The very thought of a new publication of Hitler's 'Mein Kampf' is more than disgusting and goes against ...
"This book was and will remain a pure anti-Semitic work of irrational hatred that should be forbidden for evermore. It is an abhorrent pamphlet ...

Resources last updated: 12/28/2015 2:54:14 PM