Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Visual Studios DBBackup

2 posts in General Discussion Last posting was on 2009-12-15 20:49:36.0Z
Kevin Arnold Posted on 2009-12-15 20:34:29.0Z
Sender: 163f.4b27f208.1804289383@sybase.com
From: Kevin Arnold
Newsgroups: ianywhere.public.general
Subject: Visual Studios DBBackup
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4b27f2d5.1649.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 15 Dec 2009 12:34:29 -0800
X-Trace: forums-1-dub 1260909269 10.22.241.41 (15 Dec 2009 12:34:29 -0800)
X-Original-Trace: 15 Dec 2009 12:34:29 -0800, 10.22.241.41
Lines: 3
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:7829
Article PK: 6865

Does anyone know if there is a SQL Anywhere 11 assembly for
Visual Studios that I can reference to do a DBBackup? I
would like to do a DBBackup from my C# app. TIA, Kevin.


Jeff Albion [Sybase iAnywhere] Posted on 2009-12-15 20:49:36.0Z
From: "Jeff Albion [Sybase iAnywhere]" <firstname.lastname@ianywhere.com>
User-Agent: Thunderbird 2.0.0.23 (Windows/20090812)
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: Visual Studios DBBackup
References: <4b27f2d5.1649.1681692777@sybase.com>
In-Reply-To: <4b27f2d5.1649.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4b27f660$1@forums-1-dub>
Date: 15 Dec 2009 12:49:36 -0800
X-Trace: forums-1-dub 1260910176 10.22.241.152 (15 Dec 2009 12:49:36 -0800)
X-Original-Trace: 15 Dec 2009 12:49:36 -0800, vip152.sybase.com
Lines: 35
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:7830
Article PK: 6864

Hi Kevin,

We do not have a method to do this directly from the ADO.NET provider.
However, you do have a few other options to issue a backup from C#:

1. Connect to the server as usual, and simply execute a BACKUP DATABASE
SQL statement to perform a server-side backup:
http://dcx.sybase.com/index.php#1101en/dbreference_en11/backup-statement.html

2. Make an environment call out to the command-line utility "dbbackup"
(See: http://dcx.sybase.com/index.php#1101en/dbadmin_en11/dbbackup.html )

3. Create a C++ library using our DBTools interface, and use the
"DBBackup()" function to perform a client-side backup. Make an unmanaged
external call to this library from C#. See:

http://dcx.sybase.com/index.php#1101en/dbprogramming_en11/dbt-dbbackup-function.html
http://dcx.sybase.com/index.php#1101en/dbprogramming_en11/pg-dbtools-de.html

Regards,

Kevin Arnold wrote:
> Does anyone know if there is a SQL Anywhere 11 assembly for
> Visual Studios that I can reference to do a DBBackup? I
> would like to do a DBBackup from my C# app. TIA, Kevin.

--
Jeff Albion, Sybase iAnywhere

iAnywhere Developer Community :
http://www.sybase.com/developer/library/sql-anywhere-techcorner
iAnywhere Documentation : http://www.ianywhere.com/developer/product_manuals
SQL Anywhere Patches and EBFs :
http://downloads.sybase.com/swd/summary.do?baseprod=144&client=ianywhere&timeframe=0
Report a Bug/Open a Case : http://case-express.sybase.com/cx/