Hp3000 (e or not!) to W2k

[Victor Geere]

If you want to get a feel for SQL server before you start moving data around
you can create a MSSQL Linked Server to your HP3000 data using the Minisoft ODBC
driver.  That allows you to execute Transact SQL statements againts Image.
Or better yet, do comparative queries against MSSQL and Image 
(or any other database for that matter) simultaneously.
The ODBClink/se driver doesn't work for that.

When you do start moving data, get to know MS Data Transformation Services 
in MSSQL Enterprise Manager.

The most prolific MSSQL newsgroup on the web is www.sqlteam.com .
This one for powerhouse :)

Turbo Image supports hyphens in the field names.  If you have any of those in
your database you'll need to encapsulate your field names in square brackets
[field-name] or change it to field_name.

Clustering is Microsoft's version of high availability.

Regards
Victor

>I am interested in any forum/s of ideas, "gotchas", "how to's", "watch out
>for's" etc related to Hp3000 to W2k (with SqlServer2000) Powerhouse
>migration.
>If there is a specific forum, I would appreciate a link, if the forum
>doesn't exist, then I hope it's not too late!!
>Hopefully we can pool together such resources.
>Thanks
>Sincerely, 
>Glenn Baxter
>Baxter IT Solutions
>===================================
>15 Flora Grove Ivanhoe Victoria Australia 3079
>===================================
>telephone: 61-3-9499-8687
>mobile: 0412-826-503
>fax: 61-3-9499-8344
>email:  <mailto:glenn@baxterit.com.au> glenn@baxterit.com.au