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, Microsoft Data Platform MVP
Data Warehouse and ETL Consultant
TimMitchell.net | @Tim_Mitchell | 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