Are the posted questions getting worse?
-
Where I'm at right now the current system(s) are in FoxPro. It works. I'm part of the team rewriting the HR part using .NET and SQL Server, we redesigned. Making the data migration a bit more interesting, but long-term we'll be better off.
Funny, because I've tried to talk them into moving the data, as is, into SQL Server and using the FoxPro front end. Just change to use ODBC/OLE DB to connect to the data. Couldn't get any buy-in.
Yes, you're right, that should work fine - I used to use it all the time a few years back. But hopefully you're not talking about FoxPro 2.6 or something. 🙂
The greatest enemy of knowledge is not ignorance, it is the illusion of knowledge. - Stephen Hawking
-
mtillman-921105 (10/25/2010)
Where I'm at right now the current system(s) are in FoxPro. It works. I'm part of the team rewriting the HR part using .NET and SQL Server, we redesigned. Making the data migration a bit more interesting, but long-term we'll be better off.
Funny, because I've tried to talk them into moving the data, as is, into SQL Server and using the FoxPro front end. Just change to use ODBC/OLE DB to connect to the data. Couldn't get any buy-in.
Yes, you're right, that should work fine - I used to use it all the time a few years back. But hopefully you're not talking about FoxPro 2.6 or something. 🙂
And what the heck is wrong with FoxPro 2.6? I made my living for almost a decade working with it back in the 1990's.
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2 -
Ahh, making me nostalgic for the joys of dBase 4. Now that was one hell of a way to ruin a company.
-
Jack Corbett (10/25/2010)
Grant Fritchey (10/25/2010)
Jack Corbett (10/25/2010)
So I got an email from a friend this morning asking for some SQL help. They are running a system that used to have multiple databases per location, but has been changed to use a single database with a location code. Vendor did the migration and now they have found that there are multiple people with the same ID (no PK's, unique indexes, or DRI). Now he needs to change the ID's for all the people in one location to remove duplicates. The only help he got from the vendor was a list of tables where the ID would have to be updated.I asked him for the product name so I could make sure no where I worked or made recommendations would buy it. Oh, and told him to tell the vendor they needed to bring an a SQL person to fix the database. This is a migration from FoxPro to SQL Server a few years ago, obviously with no redesign.
Ah, the good old days. I worked for a dot com who's signature product was a port from Paradox. We had to maintain backward compatibility to it as well. What a hideous monster it was.
Where I'm at right now the current system(s) are in FoxPro. It works. I'm part of the team re-writing the HR part using .NET and SQL Server, we redesigned. Making the data migration a bit more interesting, but long-term we'll be better off.
Funny, because I've tried to talk them into moving the data, as is, into SQL Server and using the FoxPro front end. Just change to use ODBC/OLE DB to connect to the data. Couldn't get any buy-in.
That really is a pretty good way to migrate something like that. I used that approach to get one of our main Oracle applications into SQL Server. I'm not too popular with our Oracle people. Like I care.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
Jeff Moden (10/24/2010)
Wow... thanks for the insight on SSIS, folks. I've mostly resisted spending any decent amount of time on it because of what I've seen. Thanks to other people's posts, it seemed that you had to write some bloody damned script for just about anything complex that you wanted to do. I kept saying to myself, "Hell, it's a lot easier to do that in T-SQL... I don't need to mess things up by getting yet another layer of stuff involved."I guess I'll give it another look... maybe even a fair one this time.
I've built solutions that automated whole business departments in SSIS, and I haven't had to write a script for it yet. It's a pretty amazing product, once you dig into it a bit and get comfortable.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
-
Today's XKCD is definitely worth a look. (It has some "NSFW language" in it.)
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
-
GSquared (10/26/2010)
Today's XKCD is definitely worth a look. (It has some "NSFW language" in it.)Excellent
-
Mission Accomplished
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events -
WayneS (10/25/2010)
mtillman-921105 (10/25/2010)
Where I'm at right now the current system(s) are in FoxPro. It works. I'm part of the team rewriting the HR part using .NET and SQL Server, we redesigned. Making the data migration a bit more interesting, but long-term we'll be better off.
Funny, because I've tried to talk them into moving the data, as is, into SQL Server and using the FoxPro front end. Just change to use ODBC/OLE DB to connect to the data. Couldn't get any buy-in.
Yes, you're right, that should work fine - I used to use it all the time a few years back. But hopefully you're not talking about FoxPro 2.6 or something. 🙂
And what the heck is wrong with FoxPro 2.6? I made my living for almost a decade working with it back in the 1990's.
Nothing in general. So did I. But the newer versions of VFP are much better to work with and version 2.6 is outdated - it came out back in '94.
Actually, I would probably still be a FoxPro developer except keeping a job with it became more and more difficult. I still miss some of the shortcut commands - ones I missed lately are SCATTER and GATHER for example.
The greatest enemy of knowledge is not ignorance, it is the illusion of knowledge. - Stephen Hawking
-
I loved Foxpro. First SQL App I wrote was an upgrade from Fox/DOS to VFP/SQL Server. Worked great!
-
Steve Jones - SSC Editor (10/26/2010)
I loved Foxpro. First SQL App I wrote was an upgrade from Fox/DOS to VFP/SQL Server. Worked great!Good, then I'm glad I don't have to be embarrassed about my FoxPro past here. 🙂
I've met programmers who would look down on xBase as if it wasn't real programming.
By the way, 2.6 (for Windows) did have one issue that caused a memory leak - the bitmaps were never released from memory, so it would eventually cause an out of memory error after going through a lot of screens. Some people claimed that all MS did for the Windows version is run the DOS version through a Windows compiler, which led to problems like that. That's my understanding of it at any rate.
The greatest enemy of knowledge is not ignorance, it is the illusion of knowledge. - Stephen Hawking
-
mtillman-921105 (10/26/2010)
Steve Jones - SSC Editor (10/26/2010)
I loved Foxpro. First SQL App I wrote was an upgrade from Fox/DOS to VFP/SQL Server. Worked great!Good, then I'm glad I don't have to be embarrassed about my FoxPro past here. 🙂
I've met programmers who would look down on xBase as if it wasn't real programming.
By the way, 2.6 (for Windows) did have one issue that caused a memory leak - the bitmaps were never released from memory, so it would eventually cause an out of memory error after going through a lot of screens. Some people claimed that all MS did for the Windows version is run the DOS version through a Windows compiler, which led to problems like that. That's my understanding of it at any rate.
Don't be embarrassed - we're still using it!
[font="Arial"]Low-hanging fruit picker and defender of the moggies[/font]For better assistance in answering your questions, please read this[/url].
Understanding and using APPLY, (I)[/url] and (II)[/url] Paul White[/url]Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]
-
GilaMonster (10/25/2010)
Tom.Thomson (10/25/2010)
I'm definitely one of those who prefers a quick solution without work. Essentially I'm extremely lazy.I think most good developers are to some degree.
Well I... nah I can't be bothered.
[font="Arial"]Low-hanging fruit picker and defender of the moggies[/font]For better assistance in answering your questions, please read this[/url].
Understanding and using APPLY, (I)[/url] and (II)[/url] Paul White[/url]Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]
-
ChrisM@home (10/26/2010)
mtillman-921105 (10/26/2010)
Steve Jones - SSC Editor (10/26/2010)
I loved Foxpro. First SQL App I wrote was an upgrade from Fox/DOS to VFP/SQL Server. Worked great!Good, then I'm glad I don't have to be embarrassed about my FoxPro past here. 🙂
I've met programmers who would look down on xBase as if it wasn't real programming.
By the way, 2.6 (for Windows) did have one issue that caused a memory leak - the bitmaps were never released from memory, so it would eventually cause an out of memory error after going through a lot of screens. Some people claimed that all MS did for the Windows version is run the DOS version through a Windows compiler, which led to problems like that. That's my understanding of it at any rate.
Don't be embarrassed - we're still using it!
OK, I won't, and I hope you don't have to spend much time after hours rebuilding .CDX's! :w00t:
(I know I did.)
The greatest enemy of knowledge is not ignorance, it is the illusion of knowledge. - Stephen Hawking
-
@Gail, how's that difficult contract going?
Today's Dilbert made me think of it:
---------------------------------------------------------------------
Use Full Links:
KB Article from Microsoft on how to ask a question on a Forum
Viewing 15 posts - 20,806 through 20,820 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply