Re: [cobalt-users] Integrating Microsoft SQL server 7.0

["E.B. Dreger" <eddy+public+spam@xxxxxxxxxxxxxxxxx>]

AS-CSE> Date: Tue, 4 Jun 2002 12:28:06 -0400 (EDT)
AS-CSE> From: Arlene Seale


AS-CSE> We have a customer who is hoping to purchase a QUBE 3 or CacheRAQ4.
AS-CSE> He is concerned about how easily Microsoft SQL Server v7 data
AS-CSE> will import into the Qube/CacheRAQ4 SQL environment.  Have any 
AS-CSE> of you done this before?  Can you let me know how easy or painful 
AS-CSE> it was?

How complex is the database?  If you want triggers and to enforce
referential integrity on foreign keys, MySQL is out; choose
PostgreSQL instead.

One can move data via various methods.  I usually set up bare
tables in PostgreSQL, dump foreign environment data into CSV/TAB
tables, load data into pgsql, then add constraints.

If accessing a pgsql database via ODBC, be sure to configure
properly pgsql beforehand.  There's a query to run that adds a
few things to template1 that are needed for ODBC clients.

Can you post more details, please?


AS-CSE> 			/\      	         
AS-CSE> 		       \\ \      Arlene Seale, Technical Specialist
AS-CSE> 		      \ \\ /     & Proposal Program Manager
AS-CSE> 		     / \/ / /    Stantive Solutions Inc.
AS-CSE> 		    / /   \//\   780 Midpark Drive, Suite 201
AS-CSE>  		    \//\   / /   Kingston, ON  Canada  K7M 7P6
AS-CSE>  		     / / /\ /    Phone: (613) 634-7410, ext. 228
AS-CSE> 		      / \\ \     Cell:  (613) 539-3766 
AS-CSE>  		       \ \\      Fax:	(613) 634-7412
AS-CSE> 		        \/       Email: arlene.seale@xxxxxxx 

Anyone else think that the ASCII-art rendition of Sun's logo
unfortunately resembles _das Hakenkreuz_?  Not as bad as WinXP,
but, still...


--
Eddy

Brotsman & Dreger, Inc. - EverQuick Internet Division
Phone: +1 (316) 794-8922 Wichita/(Inter)national
Phone: +1 (785) 865-5885 Lawrence

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Date: Mon, 21 May 2001 11:23:58 +0000 (GMT)
From: A Trap <blacklist@xxxxxxxxx>
To: blacklist@xxxxxxxxx
Subject: Please ignore this portion of my mail signature.

These last few lines are a trap for address-harvesting spambots.
Do NOT send mail to <blacklist@xxxxxxxxx>, or you are likely to
be blocked.