Re: Just one more anecdote



David Cressey wrote:
> "dawn" <dawnwolthuis@xxxxxxxxx> wrote in message
> news:1122434483.482398.180490@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
>
> > One reason why I'll stick to my partial explanation (definitely not the
> > whole of it) is that I've been involved in many migrations/conversions
> > over the past quarter of a century starting with conversions from card
> > systems to oltp and including conversions from one source code language
> > to another and one OS to another. None has been so huge and difficult
> > as the move to a SQL-DBMS environment from a very similar environment
> > to what this vendor had. I can feel this one in my bones, brother.
>
> One of the things I've done over the last quarter century is implement
> SQL-DBMS based applications that replaced prerelational precursors. I have
> not exprienced the level of difficulty you express. I think your exprience
> has led you to a flawed conclusion.
>
> I feel it in my bones, sister.

and so we have a dialog, eh? Intuition based on experience is
something I listen to, but definitely don't trust completely, even when
it is my own. I sure would like some better emperical data on this and
have tried to figure out what type of study or experiment would help.
If you have ideas, let me know.

I will say that having worked for years with IMS as a developer, not a
DBA, I would not expect the same level of difficultly migrating a
mid-size app to a SQL Server environment, for example, but I never did
it. You still have to explode lists and such, but the way schema is
used is similar. Have you worked with either PICK (e.g.
www.revelation.com) or MUMPS (e.g. Cache' from www.intersystems.com) or
anything else that might be similar to the system that was being
replaced by this .NET SQL Server implementation?

cheers! --dawn

.



Relevant Pages

  • Re: Recordset.AddNew and the recordset objects data retaining
    ... I am in an environment where bulk insert isn't an option--even though the ... underlying database is SQL server, I am using a third party OLE DB provider-- ... > insert(assuming you are using SQL server) or DTS. ...
    (microsoft.public.data.ado)
  • curious problem in production
    ... I am getting an exception from sql server being ... When I run the same code on the my development machine into the SAME ... if it fails in calling the production environment. ... RPC:Completed declare @P1 bigint ...
    (microsoft.public.sqlserver.server)
  • curious problem in production
    ... I am getting an exception from sql server being ... When I run the same code on the my development machine into the SAME ... if it fails in calling the production environment. ... RPC:Completed declare @P1 bigint ...
    (microsoft.public.sqlserver.programming)
  • curious problem in production
    ... I am getting an exception from sql server being ... When I run the same code on the my development machine into the SAME ... if it fails in calling the production environment. ... RPC:Completed declare @P1 bigint ...
    (microsoft.public.dotnet.framework.adonet)
  • curious problem in production
    ... I am getting an exception from sql server being ... When I run the same code on the my development machine into the SAME ... if it fails in calling the production environment. ... RPC:Completed declare @P1 bigint ...
    (microsoft.public.dotnet.framework.aspnet.webservices)