Re: converting from oracle to microsoft sql server

From: <martin_suttrup_at_my-deja.com>
Date: 2000/09/21
Message-ID: <8qcek9$6u$1@nnrp1.deja.com>#1/1

In article <dqqissgpi9o5pecf730c4hi2mmboclripa_at_4ax.com>, Steve . <syarbrou_at_nospam.enteract.com> wrote:
> Ok, before someone shoots me, this isn't my choice. My primary
> experience is with Oracle 8i on Solaris. Of course the company I work
> for decides they can't afford the Oracle licensing. Not that I blame
> them for the amount of hits we will be getting. I have an Oracle
> developer license of my own though and want to develop the project I'm
> working on in Oracle and then move it to SQL server. Is this possible
> and if so, how do you usually go about this? Thanks.
>
> Steve
>
> Newsgroup replies preferred. Remove nospam when replying thru email.
>

Hi Steve,

my advice would be: Don't do it.
I've been working on a porting project (SQL-Server to Oracle) the last 12 month. It was horrible. If you have many stored procedures, tables and constraints in your database it would be much to do twice. Switch to the new database as early as you can. A very good book about SQl-Server programming is "Transact-SQL Programming by Kevin Kline, O'Reilly Press".

Good luck

Martin

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Sep 21 2000 - 00:00:00 CDT