January 22, 2007 at 10:25 pm
Hi Folks,
I would like to use t-sql in 2005 to manipulate my data in sql 2000 instead of the usual query analyzer (well kinda like the rich features in MSSMS). Would I be concerned with any data integrity issue if I run my old scripts (sql 2000) in 2005 assuming all functions used are compatible with the current version? What are the pitfalls, if there's any?
January 23, 2007 at 7:43 am
Good morning,
You shouldn't run into any problems using the SQL Server Management Studio to connect to a SQL Server 2000 database. However, your T-SQL capabilities are still limited to those available in SQL Server 2000, when connecting to the older version. I use SSMS almost exclusively for my 2000 and 2005 SQL Server installations, with no problems.
Hope this helps.
Tim
Tim Mitchell
TimMitchell.net | @tmitch.net | Tyleris.com
ETL Best Practices
January 23, 2007 at 6:01 pm
You can also add the 2000 server as a linked server on one of your 2005 databases. This would give you the ability to use the 2005 features on the 2000 database.
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJanuary 23, 2007 at 8:06 pm
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply