|
Home > Archive > SQL Anywhere Mobile > May 2005 > Extracting Publication on remote
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Extracting Publication on remote
|
|
| Chance 2005-05-11, 1:24 pm |
| Does anyone have a script that can extract a publication off of a remote. I
would like to use embedded SQL scripts to define these on my remote.
tia,
chance.
| |
| Reg Domaratzki \(iAnywhere Solutions\) 2005-05-11, 1:24 pm |
| What exactly do you mean by "extract a publication" ? Are you trying to get
a list of table, the CREATE PUBLICATION command, the data from the tables in
the remote, or Something Completely Different?
--
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/swx/sdmain.stm
-> Choose SQL Anywhere Studio
-> Set "Platform Preview" and "Time Frame" to ALL
"Chance" <chance@booklog.com> wrote in message
news:42824de7$1@foru
ms-1-dub...
> Does anyone have a script that can extract a publication off of a remote.
I
> would like to use embedded SQL scripts to define these on my remote.
>
> tia,
> chance.
>
>
| |
| Chance 2005-05-11, 1:24 pm |
| Basically, what I want to do is write some SQL scripts based on an existing
publication that is defined within the remote database. When I initially did
this I used Sybase Central but now I have a need to put it into scripts.
tia,
chance.
"Reg Domaratzki (iAnywhere Solutions)" < Spam_bad_rdomarat@ia
nywhere.com>
wrote in message news:42824e5b$1@foru
ms-2-dub...
> What exactly do you mean by "extract a publication" ? Are you trying to
> get
> a list of table, the CREATE PUBLICATION command, the data from the tables
> in
> the remote, or Something Completely Different?
>
> --
> 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/swx/sdmain.stm
> -> Choose SQL Anywhere Studio
> -> Set "Platform Preview" and "Time Frame" to ALL
>
> "Chance" <chance@booklog.com> wrote in message
> news:42824de7$1@foru
ms-1-dub...
> I
>
>
| |
| Reg Domaratzki \(iAnywhere Solutions\) 2005-05-11, 8:24 pm |
| Do you need to define all the tables, or just the publication? Querying the
system table to generate CREATE TABLE commands is a very non-trivial task.
--
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/swx/sdmain.stm
-> Choose SQL Anywhere Studio
-> Set "Platform Preview" and "Time Frame" to ALL
"Chance" <chance@booklog.com> wrote in message news:428251ef@forums
-1-dub...
> Basically, what I want to do is write some SQL scripts based on an
existing
> publication that is defined within the remote database. When I initially
did
> this I used Sybase Central but now I have a need to put it into scripts.
>
> tia,
> chance.
>
> "Reg Domaratzki (iAnywhere Solutions)" < Spam_bad_rdomarat@ia
nywhere.com>
> wrote in message news:42824e5b$1@foru
ms-2-dub...
tables[color=darkred
]
remote.[color=darkred]
>
>
| |
| Chance 2005-05-11, 8:24 pm |
| Just the publication.
"Reg Domaratzki (iAnywhere Solutions)" < Spam_bad_rdomarat@ia
nywhere.com>
wrote in message news:42825338@forums
-1-dub...
> Do you need to define all the tables, or just the publication? Querying
> the
> system table to generate CREATE TABLE commands is a very non-trivial task.
>
> --
> 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/swx/sdmain.stm
> -> Choose SQL Anywhere Studio
> -> Set "Platform Preview" and "Time Frame" to ALL
>
> "Chance" <chance@booklog.com> wrote in message
> news:428251ef@forums
-1-dub...
> existing
> did
> tables
> remote.
>
>
| |
| Greg Fenton 2005-05-11, 8:24 pm |
| Chance wrote:
> Just the publication.
>
Do a schema-only unload of the database and look for the "CREATE
PUBLICATION" statement:
dbunload -c " your_connection_info
" -n unload
The above command will create a file called "reload.sql" where you can
find the CREATE PUB statement. Alternatively, you can use Sybase
Central's UNLOAD DATABASE wizard.
greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/
| |
| Chance 2005-05-12, 9:25 am |
| That works for me. Thanks.
"Greg Fenton" <greg. fenton_NOSPAM_@ianyw
here.com> wrote in message
news:42828307$1@foru
ms-1-dub...
> Chance wrote:
>
> Do a schema-only unload of the database and look for the "CREATE
> PUBLICATION" statement:
>
>
> dbunload -c " your_connection_info
" -n unload
>
> The above command will create a file called "reload.sql" where you can
> find the CREATE PUB statement. Alternatively, you can use Sybase
> Central's UNLOAD DATABASE wizard.
>
> greg.fenton
> --
> Greg Fenton
> Consultant, Solution Services, iAnywhere Solutions
> --------
> Visit the iAnywhere Solutions Developer Community
> Whitepapers, TechDocs, Downloads
> http://www.ianywhere.com/developer/
|
|
|
|
|