Replication of consolidated database to remote database; for columns added to a table in the consolidated database.
I want to find out if I add columns to a data table in the consolidated
database and then extract it for a remote database. Will the added columns
appear in the remote database automatically? or do I have to deploy the
extracted remote database by copying it to the remote machine.
Currently the consolidated database and the remote database get replicated
nightly and they have connections already established. Due to established
connections, will the extracted database automatically get deployed to the
remote machine with the updated table?
Try it, that is the best way to check ...Please help: Mobilink script is applied to the consolidated database or remote database
I have a table called Customer in both Remote and Consolidated database. In
the table there is a status field. i wrote in my end_download script:
update Customer set status = 'd' where customerID = @customerID
@customerIS is created in the begin_download script.
I understand the end_download script above will affect the consolidated
database. However, if i wrote in my end_upload script: update Customer set
status = 'u' where customerID = @customerID
@customerID is created in the begin_upload script.
I dont know if the end_upload above will affect my...Consolidating Consolidated databases
Is there a way to have a device connected to a consolidated
database (yes), and then have that consolidated database
consolidated to a centralized database? I have a need to
for a distributed POS solution where the clients may be off
line from the consolidated db and that consolidated DB may
also need to exist offline from the centralized database.
Is this doable? Would I just need to setup multiple
> Is there a way to have a device connected to a consolidated
> database (yes), and then have that consolidated database
...moving ms SQL databases
I've created a web application with Visual Studio 2003. Uploading my application to the server is easy enough. I use the Copy Project utility from the Project selection on the menu bar.
I'm using a remote server-- and hosting account that supports ASP.NET and ms SQL. But now I want to copy my ms SQL database and can't find any way to copy my DB to the server.
What do the best way to to this?
Ask your hoster. Some options are hoster specific.
The Enterprise Manager has a tool to copy databases between two servers. This is one way - but do you have the rights for this on t...Multiple consolidated databases for Mobilink
Is there a way to use Mobilink to synchronize multiple clients
(iAnywhere on PDAs) to multiple back-end databases (MS SQL Server)? If yes,
how can I configure the client to specify which database it should use to
synchronize? Any success stories or suggestions are welcomed.
Thanks in advance,
Anastasios Papadopoulos wrote:
> Hello all,
> Is there a way to use Mobilink to synchronize multiple clients
> (iAnywhere on PDAs) to multiple back-end databases (MS SQL Server)? If yes,
> how can I configure the client to specify whic...How to upgrade database changes in remote databases and consolidated databases
I am Working in a project which uses Sybase Mobilink server as the
replication system. Now I have been given a requirement to automate the
upgrade databases chages in remote databases and consolidated database.
I heard the about "Passthrough" but I don't know how to use it.
I saw below topic in our forum
PASSTHROUGH Question. How do I replicate DML ...
1.- Created a Version_Tracking Table (contains columns
Unique_Record_ID, DB_Remote_ID, DB_Version, DB_Update_Time_Stamp and
2.- The new Version_Tracking table is part of a publication that...delet mobilink client in consolidated database
How do I delete a mobilink client in the consolidated database?
I use the script below to test if the user of our program is a mobilink
WHERE user_id = :UserOfOurProgram;
Should I use:
WHERE user_id = :UserOfOurProgram;
Eric Verhorstert <firstname.lastname@example.org> wrote in news:42ea4418$1@forums-
EV> ASA 9
Please provide dbeng9 -v output.
EV> How do I delete a mobilink client in the consolidated database?
First let's a...Mobilink synchronization with Informix consolidated database
Reading chapter '2.Sinchronization Basics' of 'Mobilink
Synchronization User=b4s Guide' I see that not include bd
Informix like consolidated database. My consolidates
database is Informix what can i do?
Informix is not an officially supported consolidated database for MobiLink
synchronization. You may be able to use statement based synchronization
scripts (instead of cursor based) to get something to work, or even use ASA
with proxy tables to Informix. Keep in mind however, that Informix is not
officially supported, so if you run into difficulty, we may not have the
...Mobilink server / consolidated database in maintenance
I was wondering if there is a preferred way of dealing with
synchronisation requests whilst the consolidated database
server was down for maintenance? With the Mobilink server
stopped clients simply fail to connect a socket (as you
If there a more graceful way of information the client
database that the server is not in fact missing, just down
Thanks in advance.
MobiLink 11 126.96.36.1994
There are many approaches to address this concern.
All of which use multiple ML servers and some
redirector or load balancing.
See the det...MS SQLServer databases
I am using PowerBuilder 5.0.02 connecting to a MS SQLServer v 6.5 database
using the native driver.
When I create a new table, and then try to view the table, I get a message
that says "Tablename, colname, data type is not supported". I have tried
choosing several different data types - it does not matter what I pick.
Anybody else have this problem? Why can't I create a table
This is an old PB problem that surface when MS SQLServer 6.5 came out. Upgrade
to the latest maintenance release - 5.0.04 - from the we...Problem Mobilink With Trigger on Consolidate Database
I have some problem about Mobilink .
I have 3 table . table A , B and C
all 3 table are consolidate database (Sybase ASE 15)
- table A have trigger update by update table C
- table B have not trigger
Remote Database ( ASA)
- Have table A ,C
Problem : When i update table A and i insert table C then Sync , I
E. 06/26 11:06:29. SQLCODE from MobiLink server is: -10002
E. 06/26 11:06:29. Message: ...mobilink with sql server as consolidated database
I am using sql server 2000 as consolidated database and in the device I am
using asa 10.0.1.3686 with Pocket Builder 2.5
previously in sybase 9 I have that to manage a temporal table in the
mobilink to manage environment variable that used in the different events,
the same thing happens in mobilink 10, when I work with sql server like
"LAPI" <email@example.com> wrote in news:48359692@forums-1-dub:
> I am using sql server 2000 as consolidated database and in the device I am
> using asa 10.0.1.3686 with Pocket Builder 2.5...MS SQLServer databases - data types
Concerning my data type problem (MS SQLServer databases - data types) - I do
not have any problem when I connect to the database using ODBC - with the
SQL Server driver.
...Move SQL Server to Ms Access Database
Helo, I'm a newbie in DNN3. There are some question that I would like to ask. 1) How to change the web.comfig from SQL server to MS Access? sqlDataprovider is same as SQL server? I'd tried to put <appSettings> <add key="ConnectionString"value="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\myPath\myJet.mdb;User ID=;Password=" /></appSettings>in my web.config file. but seems does not work properly in my localhost. 2) Another thing is, when i put Imports System.ConfigurationDim Conn As New OleDbConnection(ConfigurationSettings.AppSetti...