| Author |
exporting stored procedures
|
|
| Zehra Konuk 2005-04-12, 8:23 pm |
| I noticed that when I unload my ASA9 database it generates sql for tables
only not for stored procedures and triggers.
Is there an easy way to export stored procedures from one database and
import it into another database?
Thanks.
| |
| Chris Keating \(iAnywhere Solutions\) 2005-04-12, 8:23 pm |
| DBUNLOAD and the Sybase Central Unload should generate a full schema.How do
you unload it? What options are you selecting?
--
Chris Keating
Sybase Adaptive Server Anywhere Professional Version 8
********************
********************
********************
*****************
Sign up today for your copy of the SQL Anywhere Studio 9 Developer Edition
and try out the market-leading database for mobile, embedded and small to
medium sized business environments for free!
http://www.ianywhere.com/promos/deved/index.html
********************
********************
********************
*****************
iAnywhere Solutions http://www.iAnywhere.com
** Please only post to the newsgroup
** Whitepapers can be found at http://www.iAnywhere.com/developer
** EBFs can be found at http://downloads.sybase.com/swx/sdmain.stm
** Use CaseXpress to report bugs http://casexpress.sybase.com
********************
********************
********************
*****************
"Zehra Konuk" <zkonuk@datascan.com> wrote in message
news:425c3910$1@foru
ms-1-dub...
>I noticed that when I unload my ASA9 database it generates sql for tables
>only not for stored procedures and triggers.
> Is there an easy way to export stored procedures from one database and
> import it into another database?
>
> Thanks.
>
| |
| Zehra Konuk 2005-04-13, 9:23 am |
| Thank you Chris.
I was using SYBASE CENTRAL UNLOAD, and it does generate the scripts for the
stored procedures. Sorry it is my mistake that I didn't see them at the end
of the file.
My next question is this : Is there a way to only unload the stored
procedures ?
Thank,
Zehra
| |
| Chris Keating \(iAnywhere Solutions\) 2005-04-13, 9:23 am |
| There is not. But you can query system tables to get the procedure script to
meet this requriement.
"Zehra Konuk" <zkonuk@datascan.com> wrote in message
news:425d26b2$1@foru
ms-2-dub...
> Thank you Chris.
> I was using SYBASE CENTRAL UNLOAD, and it does generate the scripts for
> the stored procedures. Sorry it is my mistake that I didn't see them at
> the end of the file.
>
> My next question is this : Is there a way to only unload the stored
> procedures ?
>
> Thank,
> Zehra
>
>
>
| |
| Joshua Savill 2005-04-13, 9:23 am |
| Zehra,
There is no direct way of unloading just the stored procedure. You can cut
the section of the stored procedure SQL code from the reload.sql file and
run this SQL into the database to create the stored procedures.
--
Joshua Savill
iAnywhere Solutions - Product Support Analyst
"Zehra Konuk" <zkonuk@datascan.com> wrote in message
news:425d26b2$1@foru
ms-2-dub...
> Thank you Chris.
> I was using SYBASE CENTRAL UNLOAD, and it does generate the scripts for
> the stored procedures. Sorry it is my mistake that I didn't see them at
> the end of the file.
>
> My next question is this : Is there a way to only unload the stored
> procedures ?
>
> Thank,
> Zehra
>
>
>
| |
| Greg Fenton 2005-04-13, 8:23 pm |
| Zehra Konuk wrote:
>
> My next question is this : Is there a way to only unload the stored
> procedures ?
>
With version 9 of Sybase Central, you can right-click a stored
procedure, choose "Copy" and then paste into your favourite text editor
(or even Notepad).
greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/
|
|
|
|