Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
cbutler.spinsys
Starting Member
2 Posts |
 Posted - 2010-06-17 : 14:37:51
|
| Hello, I'm slightly new to the world of SQL server, & I am working on an application which contains SQL scripts which contain outdated "=*", "*=" and other now-illegal syntax. These query scripts are not part of the database, but rather were decompiled from the old application. Would anyone be able to tell me an easy way that I may take these outdated scripts and 'upgrade' the syntax to be compatible with SQL server 2008? I figured a third party software or query analyzer would help, but am not sure what to try. Any help appreciated, thanks!-Chris |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
cbutler.spinsys
Starting Member
2 Posts |
Posted - 2010-06-17 : 15:33:34
|
Hmmm... I would have thought there would be software that can take in the old SQL script and bring it up to par. Some of the scripts are rather complex  |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2010-06-17 : 19:24:56
|
| Yeah, its a good point, but I can't say I've ever heard of one. It would probably have to compile the script and then reverse-generate new-style syntax from that in order to maintain the logic. That's quite a lot of work for a one-off-converter, so maybe no-one ever thought they would get payback ... or maybe its easy using YACC or somesuch ...Having said that, over the years I have built upgrade-converters to get us from one platform to another which were very much one-off projects - I built one to get us from North Star Basic to C back in the '80s and called StarShip; if only there had been a corporate market for it and I could have had an Enterprise version! |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2010-06-17 : 20:16:58
|
| swisssql.com maybe? |
|
|
|
|
|
|
Converting old SQL scripts to be compatible...