ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Installation >> Moving Existing DBA Classic to a new server
http://www.istechforum.com/YaBB.pl?num=1179429133

Message started by precision on 05/17/07 at 12:12:12

Title: Moving Existing DBA Classic to a new server
Post by precision on 05/17/07 at 12:12:12

Hi,
We have DBA Classic 2002.4 installed on a computer that runs NT Server 4. We have a small peer-to-peer network with 4 workstations all of which have access to the main DBA database on our server.

I want to update and get a new server that runs windows 2003. Is the version of DBA Classic that I have compatible with windows 2003 server? And how do I go about transferring data? Thanks in advance for your help.

Erika

Title: Re: Moving Existing DBA Classic to a new server
Post by GasGiant on 05/17/07 at 13:15:44

What version of Pervasive?

Title: Re: Moving Existing DBA Classic to a new server
Post by Lynn_Pantic on 05/21/07 at 18:09:36

Colin is correct, the Pervasive version is what is significant, not DBA. DBA itself will run fine but Pervasive 2000 is not supported in WIN 2003 server. Upgrading to PSQL 9.5 is recommended. For 5 or fewer users, you can use the PSQL Workgroup product which is only $25/user.

Title: Re: Moving Existing DBA Classic to a new server
Post by cmsk on 05/22/07 at 04:17:53

Lynn_Pantic wrote:

How's that Lynn??!?! We are on Pervasive 2000i on Win2003 Server. Is this not supposed to be??

Title: Re: Moving Existing DBA Classic to a new server
Post by kkmfg on 05/22/07 at 04:33:33

cmsk wrote:

[quote author=Lynn_Pantic link=1179429133/0#2 date=1179799776]Colin is correct, the Pervasive version is what is significant, not DBA. DBA itself will run fine but Pervasive 2000 is not supported in WIN 2003 server. Upgrading to PSQL 9.5 is recommended. For 5 or fewer users, you can use the PSQL Workgroup product which is only $25/user.

Title: Re: Moving Existing DBA Classic to a new server
Post by cmsk on 05/22/07 at 05:12:41

kkmfg wrote:

[quote author=cmsk link=1179429133/0#3 date=1179836273][quote author=Lynn_Pantic link=1179429133/0#2 date=1179799776]Colin is correct, the Pervasive version is what is significant, not DBA. DBA itself will run fine but Pervasive 2000 is not supported in WIN 2003 server. Upgrading to PSQL 9.5 is recommended. For 5 or fewer users, you can use the PSQL Workgroup product which is only $25/user.

How's that Lynn??!?! We are on Pervasive 2000i on Win2003 Server. Is this not supposed to be??
[/quote]

There is a difference between "not supported" and "can't do it"

Of course, it means that you SHOULDN'T do it. It's sort of like how you *shouldn't* spit into the wind. Can you? Sure! But it's not a winning idea.[/quote]

LOL, Thanks for that analogy.

Okay, so if I understand this correctly, we should upgrade to PSQL 9.5 to avoid any spittle in the eye?!!?

Title: Re: Moving Existing DBA Classic to a new server
Post by kkmfg on 05/22/07 at 07:00:46

:-) Yes, it'd be for the best if you upgraded to 9.5

Title: Re: Moving Existing DBA Classic to a new server
Post by cmsk on 05/22/07 at 07:11:05

Okies, thanks for the info.

Title: Re: Moving Existing DBA Classic to a new server
Post by Lynn_Pantic on 05/22/07 at 13:17:35

IS Tech is a Pervasive reseller & can get upgrade pricing so you do not have to pay the full price.

Title: Re: Moving Existing DBA Classic to a new server
Post by cmsk on 05/22/07 at 15:23:21

Lynn_Pantic wrote:

IS Tech is a Pervasive reseller & can get upgrade pricing so you do not have to pay the full price.

Lynn, I'll contact you directly about this, thanks.

Title: Re: Moving Existing DBA Classic to a new server
Post by precision on 05/25/07 at 09:17:39

Hi again,
We have Pervassive Version 2000i, so I see I need to buy the upgraded version and I will do that as soon as I order our server. Thank you. One more question, I thought I read somewhere that I'd have some problems w/ having a Win 2003 server & DBA & having our peer to peer network hooked up through a hub which is how we have it set up now. Is that true? Something about setting our network up this way slows things down. It probably isn't true but I just want to be safe and ask.
Also, this is a very insightful forum. Thanks for offering it.

Title: Re: Moving Existing DBA Classic to a new server
Post by Lynn_Pantic on 06/11/07 at 17:37:20

Moving DBA to a new server is now a HOWTO on the Wiki.

I am not aware of any problems with the network architecture you described.

Title: Re: Moving Existing DBA Classic to a new server
Post by davidgomez on 08/20/07 at 13:30:57

Can anyone tell me the exact procedure to move DBA to a new server. I'm trying to move from Win 2000 Server to Windows 2003 SBS. I tried the procedure posted on the WIKI but it did not work. I tried both PSQL 2000i and PSQL ver. 9 with no luck. I keep getting the following error when trying the Maintain Database:

Btrieve status 35 - The application encountered a directory error.
Key = Id: \programs\dbamfgDEFAULT\ file name (file name = Whatever file I'm trying to access)
DB1ERR_INVALIDDIR

Any help will be appriciated.

Title: Re: Moving Existing DBA Classic to a new server
Post by Lynn_Pantic on 08/27/07 at 17:05:17

If the only error is using Maintain Database, then UT-A, program MDBFXREG should fix it.

Title: Re: Moving Existing DBA Classic to a new server
Post by davidgomez on 09/05/07 at 09:22:52

Thanks Lynn, I was able to resolve the problem using the program you suggested.