March 26, 2008 at 2:20 pm
Hi,
Is there any known Issues relating to Comparing data sets stored between SQL 2K and SQL 2K5.
I'm on the verge of making use of sql 2k5 to store data and to be able to get updates whenever possible.
To retrieve updates we might need to compare table columns between the two different version.
Is there any issue or anything which need to take into consideration during implementation?
Thanks,
Ignas
March 26, 2008 at 3:48 pm
If you are simpling comparing tables then making updates/inserts/deleting, I really do not forsee a problem.
Some things to note are:
- certain features are available for 2005, that are not available in 2000.
- certain features are available for 2000, that have been removed for 2005
- SQL 2005 is much more strict on syntax
- SQL 2005 does not like SQL 2000 code like =*
Bottom line, if your is 100% compatible with 2000, then I really would not expect to see any problems. If you are using objects or features that are either exclusive to 2000 or 2005 then you will run into problems.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply