If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > Informix > DB Migration to New server -Any suggestions Urgent

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 09-14-03, 19:16
kpai kpai is offline
Registered User
 
Join Date: Sep 2003
Location: Auckland - Newzealand
Posts: 1
Question DB Migration to New server -Any suggestions Urgent

Hi All

We are running production box with informix 9.21 on solaris, the present database has installed with DATABLADES
(ETX,LLD adn TXT) but we are not using any blobs, clobs ,rowdatatypes etc in our database.
Separate webserevr running tomcat.

We got a new database server for a better performance with more memory and disks ,we have installed
the same version of informix on new box without creating SBSPACES.

We have migrate the database to new server adn put on production.

For testing , i did dbexport from the present server, edited the .sql file removed all the code related to
datablade procedures, tables, functions, datatypes etc. Did dbimport on new server, and our application
looks working fine.

We want to run our application on new server without datablades and sbspaces.
Is the above method is fine to migrate the database, or do i need to lok at any other areas?
And also could you please suggest how do i put the new database server for load testing?
So that i can do some performance measure.

Any ideas, suggestions will be much appreciated!!!
Thanks Heaps
Kalpana Pai
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On