May 14, 2007 at 11:51 am
Hello Friends.
(Sorry about my English.)
I'm working with Access databases for about 6 Years now. Now it's the moment when there is no more place to work with this databases. IT'S TOO SLOW AND IT's Coruptet now and then.....
But there is a bigger problem than upsizing the databases to SQL Server 2005. There are about 10 active projects (written in VB6) that can't be managed no more with Access, but there are about 20 000 lines of SQL code that need to be capable to work with SQL Server. Only the simple SQL-s work with the SQL Server. I'm very dissapointed with Microsoft, so big and so powerfull company does not support and do not have the sollutions to manage the code and functions (written by themselves) so that the developers that have worked on Access on the simplyest way transfer the code to SQL Server.....
There are 1000-s of IIF-s, Format-s, Shape-s.... in my code, there is no way to code this again, and there is no way to upgade this code to SQL that is supported in SQL Server....
Is there a solution to send this (fully working in Access) SQL codes to transform it so that it will work in SQL Server.
Maybe thru some custom functions (IIF and in there to define it with cases)?
I can't figure it out for a few months now.
Any help from You guys will be more then a help.
I'm in such a big trouble, that I'm thinking to leave this big projects because I made a big mistake when I was cusing a database.
Thanks Davor.
May 14, 2007 at 12:26 pm
Why not try to write user defined scalar functions that mimic this access behaviour?
Jan
May 14, 2007 at 12:52 pm
Thnx Jan for Your reply.
I'm heaving the same Idea, but I wanted to see if there is some another approach or how did others manage this problem.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply