Networks
by muthu19485
Hi,
We hav developed a software with VB6.0 as frontend and access2000 as a backend.
And now am interested to convert the database access to sql sever2000.For that wat are the steps I have to do?
First as posted simply change the connection string.
Then test, see if you've got any access specific non standard SQL
How easy that is depends on how modular your code is.
Then potentially ( almost certainly) optimise.
Generally when scaling a desktop backend to a full DBMS, your problem areas will be
locking, transaction isolation and it being dog slow because you did a lot of the data processing in code instead of in the database.
How much work the above is depends on way too many factors, in my experience having done this sort of thing several times it always turns out to be a lot more management hoped.
by sanjay_nccb
by krg_b
This discussion is closed to new replies.
Sort by Trending