SQL Anywhere Mobile - Deploy Mobilink Scripts

Author

Deploy Mobilink Scripts

rr12

2006-02-01, 8:29 pm

(9.0.2.3228) (UL.NET + ASA Consolidated)

Now that I have developed the appropriate scripts and
procedures for the ML synchronization in my reference
database; what is the best way to get these scripts out of
the ref database and into an existing ASA database?
(Specifically, items from ml_table, ml_script_version,
ml_table_script, and ml_script, etc.)

What I'm looking for is a method which will work as part of
deployment.

Thanks

rr12

rr12

2006-02-01, 8:29 pm

(answering my own question here)

Create a .sql file which contains calls to
ml_add_connection_sc
ript and ml_add_table_script. When you
use those functions they will automatically add all the
appropriate entries to the ml_* tables.

On installation, use dbisql to run .sql file against the
database.

rr12

> (9.0.2.3228) (UL.NET + ASA Consolidated)
>
> Now that I have developed the appropriate scripts and
> procedures for the ML synchronization in my reference
> database; what is the best way to get these scripts out of
> the ref database and into an existing ASA database?
> (Specifically, items from ml_table, ml_script_version,
> ml_table_script, and ml_script, etc.)
>
> What I'm looking for is a method which will work as part
> of deployment.
>
> Thanks
>
> rr12

Reg Domaratzki \(iAnywhere Solutions\)

2006-02-02, 7:24 am

The following SQL run against an ASA consolidated that already has the synch
scripts defined with create the .SQL file for you. Note that there are no
double quotes in the SQL below, they are all single quotes.

unload
select 'call dbo. ml_add_lang_table_sc
ript( ''' ||
REPLACE(dbo.ml_script_version.name, '''', '''''') || ''', ''' ||
REPLACE(dbo.ml_table.name, '''', '''''') || ''', ''' ||
dbo.ml_table_script.event || ''', ''' ||
dbo.ml_script.script_language || ''', ''' ||
REPLACE(dbo.ml_script.script, '''', '''''') || ''');'
from dbo.ml_table_script,
dbo.ml_script_version,
dbo.ml_script,
dbo.ml_table
where dbo.ml_table_script.version_id =
dbo.ml_script_version.version_id
and dbo.ml_table_script.script_id = dbo.ml_script.script_id
and dbo.ml_table_script.table_id = dbo.ml_table.table_id
union all
select 'call dbo. ml_add_lang_connecti
on_script( ''' ||
REPLACE(dbo.ml_script_version.name, '''', '''''') || ''', ''' ||
dbo. ml_connection_script
.event || ''', ''' ||
dbo.ml_script.script_language || ''', ''' ||
REPLACE(dbo.ml_script.script, '''', '''''') || ''');'
from dbo. ml_connection_script
,
dbo.ml_script_version,
dbo.ml_script
where dbo. ml_connection_script
.version_id =
dbo.ml_script_version.version_id
and dbo. ml_connection_script
.script_id = dbo.ml_script.script_id
to 'c:\\temp\\mlscript.sql'
format ascii quotes off escapes off;

--
Reg Domaratzki, Sybase iAnywhere Solutions
Sybase Certified Professional - Sybase ASA Developer Version 8
Please reply only to the newsgroup

iAnywhere Developer Community : http://www.ianywhere.com/developer
iAnywhere Documentation : http://www.ianywhere.com/developer/product_manuals
ASA Patches and EBFs : http://downloads.sybase.com/swd/base.do
-> Choose SQL Anywhere Studio
-> Set filter to "Display ALL platforms IN ALL MONTHS"

<rr12> wrote in message news:43e1652a.5632.1681692777@sybase.com...[color=darkred]
> (answering my own question here)
>
> Create a .sql file which contains calls to
> ml_add_connection_sc
ript and ml_add_table_script. When you
> use those functions they will automatically add all the
> appropriate entries to the ml_* tables.
>
> On installation, use dbisql to run .sql file against the
> database.
>
> rr12
>
>

Sponsored Links