RE: how to transfer my database to another machine.

2004-03-26 Thread PcgScrapAddy
make a backup of type 'Migration' using the DBMGUI. setup a new instance of type 'migration' in the target server. that is it in a nutshell. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, March 26, 2004 1:02 AM To: [EMAIL PROTECTED] Subject: how to tran

how to transfer my database to another machine.

2004-03-26 Thread sunilbachu
hi, I'm using maxdb to store my database and the version is 7.5 and now i want to dump my database with data into another machine. for this i didnt have any network to that machine all i have to do is to make a backup and copy it to that machine and create the same database there. as the size

Re: MaxDB with .NET

2004-03-26 Thread iml-sapdb
I will chime in... First off, we have seen no difference between 7.3 / 7.4 / 7.5 versions. The driver is independent. I believe you can even use a 7.5 ODBC driver against an older xserver/kern. I'm a bit confused why so many people on the list aren't upgrading to 7.5? Older releases are no

New Version of MaxDB Documentation in English and German

2004-03-26 Thread Montag, Marina
Hello, A new version of the MaxDB 7.5 documentation is available now at http://www.mysql.com/products/maxdb/docs.html. Besides the online version in English you can now download the complete MaxDB Library in English and German in plain html and HTMLHelp format each. Whereas the plain HTML versi

DROP TABLE IF EXISTS

2004-03-26 Thread Pfrommer. Dominik
hi everybody... i am searching for sth. equivalent like: MySQL: DROP TABLE IF EXISTS tMyTable M$SQL: if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tMyTable]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[tMyTable] GO can anybody help me? as a workaround

RE: Question volume name

2004-03-26 Thread Heinrich, Tilo
Hello Chris, you could use the DOS-Name for "d:\a b\". You can determine DOS-Names, in a command prompt with the command "dir /X d:\". Best Regards, Tilo Heinrich SAP Labs Berlin -Original Message- From: Christoph Weser [mailto:[EMAIL PROTECTED] Sent: Friday, March 26, 2004 3:42 PM To:

AW: Question volume name

2004-03-26 Thread Weinmann, Alexander
Hello, At the moment the only workaround is avoiding spaces. There is already a development request to remove this limitation, but I cannot tell you when this will change Regards, Alexander Weinmann > -Ursprüngliche Nachricht- > Von: Christoph Weser [mailto:[EMAIL PROTECTED] > Ge

AW: Question volume name

2004-03-26 Thread Christoph Weser
Thanx Alexander for your quick response. Is there a workaround (instead of not using space-containing paths. :-)?? Could you even image one? Thanx a lot! Chris -Ursprüngliche Nachricht- Von: Weinmann, Alexander [mailto:[EMAIL PROTECTED] Gesendet: Freitag, 26. März 2004 15:18 An: maxdb (

AW: Question volume name

2004-03-26 Thread Weinmann, Alexander
Hello, You should use paths without spaces! param_addvolume does not support paths containing spaces at the moment. Regards, Alexander Weinmann > -Ursprüngliche Nachricht- > Von: Christoph Weser [mailto:[EMAIL PROTECTED] > Gesendet: Freitag, 26. März 2004 15:12 > An: maxdb (E-Mail) >

Question volume name

2004-03-26 Thread Christoph Weser
Hello everybody. I tried tis: dbmcli -d seetec -u dbm,seetecdbm param_addvolume 1 DATA d:\a b\DISKD001 F 2 The RDBMS replied: ERR -24946,ERR_TOOMANYPARAM: too many parameters So how to mask a path name containing spaces??? I tried ' " ' with no success. Any help? Thanx! Chris -- MaxDB

index creation with "big" tables

2004-03-26 Thread Martin Lackner
Hello! The creation of an index for the following table is on my sapdb installation very slow. CREATE TABLE Buchungssaetze ( ID INT NOT NULL, TS INT NOT NULL, Transaktion INT NOT NULL, Sollbuchung BOOLEAN NOT NULL, Art INT NOT NULL, Konto INT NOT NULL, Kostenstelle INT NOT NULL,

Re: MaxDB with .NET

2004-03-26 Thread Marcin P
Yes - but only with standard ODBC driver (use .NET provider for ODBC drivers). It works perfect with 7.3.0.46. (I haven't yet tested 7.4 nor 7.5). Lool at my latest post concerning Mono and Daniel's answer - http://www.bytefx.com/Products.aspx It seems the .NET Provider for MaxDB/SAP DB is on the w