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.

Easiest way to migrate users?

5 posts in General Discussion Last posting was on 2008-05-08 19:57:42.0Z
Shao Chan Posted on 2008-05-07 09:42:38.0Z
Sender: 1a23.48207263.1804289383@sybase.com
From: Shao Chan
Newsgroups: ianywhere.public.mbusinessanywhere.general
Subject: Easiest way to migrate users?
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4821798e.3d40.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 7 May 2008 02:42:38 -0700
X-Trace: forums-1-dub 1210153358 10.22.241.41 (7 May 2008 02:42:38 -0700)
X-Original-Trace: 7 May 2008 02:42:38 -0700, 10.22.241.41
Lines: 21
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.mbusinessanywhere.general:1189
Article PK: 9295

Hi all,

If I have an M-Biz application setup and around 1000 users
setup in the database which I wish to transfer to another
system possibly running a different version of M-Biz, what
is the best way to copy the users across?

As far as I can tell:

1) I can export the users from system A and import them into
system B. However, this functionality does not work well
and passwords are omitted.

2) I can write code that will export the contents of the
relevant table, but are there any adverse effects? Do I
need to update any counters / sequences? Are the passwords
encrpted in a way that I need to look out for?

Cheers,

Shao


David Fishburn Posted on 2008-05-07 15:28:55.0Z
Newsgroups: ianywhere.public.mbusinessanywhere.general
Subject: Re: Easiest way to migrate users?
From: David Fishburn <fishburn_spam_off@ianywhere.com>
References: <4821798e.3d40.1681692777@sybase.com>
Organization: iAnywhere Solutions
Message-ID: <Xns9A9774CD39991fishburnsybasecom@10.22.241.106>
User-Agent: Xnews/2005.10.18
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Date: 7 May 2008 08:28:55 -0700
X-Trace: forums-1-dub 1210174135 10.22.241.152 (7 May 2008 08:28:55 -0700)
X-Original-Trace: 7 May 2008 08:28:55 -0700, vip152.sybase.com
Lines: 44
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.mbusinessanywhere.general:1191
Article PK: 17907

Shao Chan wrote in news:4821798e.3d40.1681692777@sybase.com
of ianywhere.public.mbusinessanywhere.general:

SC> If I have an M-Biz application setup and around 1000 users
SC> setup in the database which I wish to transfer to another
SC> system possibly running a different version of M-Biz, what
SC> is the best way to copy the users across?
...
SC> 2) I can write code that will export the contents of the
SC> relevant table, but are there any adverse effects? Do I
SC> need to update any counters / sequences? Are the passwords
SC> encrpted in a way that I need to look out for?

Are there already users in the other system?
In other words, will the userid be the same in the other database?

You never specified which versions of MBiz you are using.

You can do this a couple of different ways:
1. Use DBISQL connected to the AGDB database.
2. Use the SOAP API (provided by MBiz) using Java or .Net.

Depends if you think you might do this again down the road.
--
David Fishburn
Certified ASA Developer Version 8
iAnywhere Solutions - Sybase
Professional Services
Please only post to the newsgroup
Please ALWAYS include version and MORE importantly BUILD number with
EACH post (dbeng10 -v).

EBFs and Maintenance Releases
http://downloads.sybase.com/

Developer Community / Whitepapers
http://www.ianywhere.com/developer

Case-Express - to report bugs
http://case-express.sybase.com

CodeXchange - Free samples
http://ianywhere.codexchange.sybase.com/servlets/ProjectDocumentList


Shao Chan Posted on 2008-05-07 21:58:48.0Z
From: "Shao Chan" <noreply@civica.co.uk>
Newsgroups: ianywhere.public.mbusinessanywhere.general
References: <4821798e.3d40.1681692777@sybase.com> <Xns9A9774CD39991fishburnsybasecom@10.22.241.106>
Subject: Re: Easiest way to migrate users?
Lines: 66
Organization: Civica
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <48222618@forums-1-dub>
Date: 7 May 2008 14:58:48 -0700
X-Trace: forums-1-dub 1210197528 10.22.241.152 (7 May 2008 14:58:48 -0700)
X-Original-Trace: 7 May 2008 14:58:48 -0700, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.mbusinessanywhere.general:1197
Article PK: 17911

Hi Dave,

Thanks for that.

Sorry, customer has a test system on 6.7 and a live system on 6.2.

I can easily connect to AGDB but I am not 100% sure of where to retrieve
data for M-Biz's own tables.

If I just find the user table and generate a record in there, will it be
fine or are there associated records that I need to create. I just want to
know if there are any gotcha's if I start writing to the AGDB database.

Cheers,

Shao

"David Fishburn" <fishburn_spam_off@ianywhere.com> wrote in message
news:Xns9A9774CD39991fishburnsybasecom@10.22.241.106...
> Shao Chan wrote in news:4821798e.3d40.1681692777@sybase.com
> of ianywhere.public.mbusinessanywhere.general:
>
> SC> If I have an M-Biz application setup and around 1000 users
> SC> setup in the database which I wish to transfer to another
> SC> system possibly running a different version of M-Biz, what
> SC> is the best way to copy the users across?
> ...
> SC> 2) I can write code that will export the contents of the
> SC> relevant table, but are there any adverse effects? Do I
> SC> need to update any counters / sequences? Are the passwords
> SC> encrpted in a way that I need to look out for?
>
> Are there already users in the other system?
> In other words, will the userid be the same in the other database?
>
> You never specified which versions of MBiz you are using.
>
> You can do this a couple of different ways:
> 1. Use DBISQL connected to the AGDB database.
> 2. Use the SOAP API (provided by MBiz) using Java or .Net.
>
> Depends if you think you might do this again down the road.
> --
> David Fishburn
> Certified ASA Developer Version 8
> iAnywhere Solutions - Sybase
> Professional Services
> Please only post to the newsgroup
> Please ALWAYS include version and MORE importantly BUILD number with
> EACH post (dbeng10 -v).
>
> EBFs and Maintenance Releases
> http://downloads.sybase.com/
>
> Developer Community / Whitepapers
> http://www.ianywhere.com/developer
>
> Case-Express - to report bugs
> http://case-express.sybase.com
>
> CodeXchange - Free samples
> http://ianywhere.codexchange.sybase.com/servlets/ProjectDocumentList
>


David Fishburn Posted on 2008-05-08 13:10:48.0Z
Newsgroups: ianywhere.public.mbusinessanywhere.general
Subject: Re: Easiest way to migrate users?
From: David Fishburn <fishburn_spam_off@ianywhere.com>
References: <4821798e.3d40.1681692777@sybase.com> <Xns9A9774CD39991fishburnsybasecom@10.22.241.106> <48222618@forums-1-dub>
Organization: iAnywhere Solutions
Message-ID: <Xns9A985D627741fishburnsybasecom@10.22.241.106>
User-Agent: Xnews/2005.10.18
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Date: 8 May 2008 06:10:48 -0700
X-Trace: forums-1-dub 1210252248 10.22.241.152 (8 May 2008 06:10:48 -0700)
X-Original-Trace: 8 May 2008 06:10:48 -0700, vip152.sybase.com
Lines: 57
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.mbusinessanywhere.general:1199
Article PK: 9302

"Shao Chan" <noreply@civica.co.uk> wrote in news:48222618@forums-1-dub
of ianywhere.public.mbusinessanywhere.general:

SC> Sorry, customer has a test system on 6.7 and a live system on 6.2.
SC>
SC> I can easily connect to AGDB but I am not 100% sure of where to
SC> retrieve data for M-Biz's own tables.
SC>
SC> If I just find the user table and generate a record in there, will
it
SC> be fine or are there associated records that I need to create. I
just
SC> want to know if there are any gotcha's if I start writing to the
AGDB
SC> database.

That is the reason using the SOAP API is the "right" way to do it.
It will populate the AGDB database correctly.

The SOAP API is used by the admin console.

Under:
m-businessanywhereserver\samples

There are 2 directories, one for Java and one for .Net.

I would highly suggest looking at the csharp example.
It shows how to create users (and other things).

I would connect to your 6.2 server (via SOAP), retrieve the
information and populate the 6.7 test server.

If most of the code has been provided, it shoudn't be too difficult.
I have been using this API.


--
David Fishburn
Certified ASA Developer Version 8
iAnywhere Solutions - Sybase
Professional Services
Please only post to the newsgroup
Please ALWAYS include version and MORE importantly BUILD number with
EACH post (dbeng10 -v).

EBFs and Maintenance Releases
http://downloads.sybase.com/

Developer Community / Whitepapers
http://www.ianywhere.com/developer

Case-Express - to report bugs
http://case-express.sybase.com

CodeXchange - Free samples
http://ianywhere.codexchange.sybase.com/servlets/ProjectDocumentList


Shao Chan Posted on 2008-05-08 19:57:42.0Z
From: "Shao Chan" <noreply@civica.co.uk>
Newsgroups: ianywhere.public.mbusinessanywhere.general
References: <4821798e.3d40.1681692777@sybase.com> <Xns9A9774CD39991fishburnsybasecom@10.22.241.106> <48222618@forums-1-dub> <Xns9A985D627741fishburnsybasecom@10.22.241.106>
Subject: Re: Easiest way to migrate users?
Lines: 71
Organization: Civica
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <48235b36$1@forums-1-dub>
Date: 8 May 2008 12:57:42 -0700
X-Trace: forums-1-dub 1210276662 10.22.241.152 (8 May 2008 12:57:42 -0700)
X-Original-Trace: 8 May 2008 12:57:42 -0700, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.mbusinessanywhere.general:1200
Article PK: 9301

Hi Dave,

Ah, I see what you mean! :)

I was thinking in terms of unloading and reloading.

Cheers,

Shao

"David Fishburn" <fishburn_spam_off@ianywhere.com> wrote in message
news:Xns9A985D627741fishburnsybasecom@10.22.241.106...
> "Shao Chan" <noreply@civica.co.uk> wrote in news:48222618@forums-1-dub
> of ianywhere.public.mbusinessanywhere.general:
>
> SC> Sorry, customer has a test system on 6.7 and a live system on 6.2.
> SC>
> SC> I can easily connect to AGDB but I am not 100% sure of where to
> SC> retrieve data for M-Biz's own tables.
> SC>
> SC> If I just find the user table and generate a record in there, will
> it
> SC> be fine or are there associated records that I need to create. I
> just
> SC> want to know if there are any gotcha's if I start writing to the
> AGDB
> SC> database.
>
> That is the reason using the SOAP API is the "right" way to do it.
> It will populate the AGDB database correctly.
>
> The SOAP API is used by the admin console.
>
> Under:
> m-businessanywhereserver\samples
>
> There are 2 directories, one for Java and one for .Net.
>
> I would highly suggest looking at the csharp example.
> It shows how to create users (and other things).
>
> I would connect to your 6.2 server (via SOAP), retrieve the
> information and populate the 6.7 test server.
>
> If most of the code has been provided, it shoudn't be too difficult.
> I have been using this API.
>
>
> --
> David Fishburn
> Certified ASA Developer Version 8
> iAnywhere Solutions - Sybase
> Professional Services
> Please only post to the newsgroup
> Please ALWAYS include version and MORE importantly BUILD number with
> EACH post (dbeng10 -v).
>
> EBFs and Maintenance Releases
> http://downloads.sybase.com/
>
> Developer Community / Whitepapers
> http://www.ianywhere.com/developer
>
> Case-Express - to report bugs
> http://case-express.sybase.com
>
> CodeXchange - Free samples
> http://ianywhere.codexchange.sybase.com/servlets/ProjectDocumentList
>