sql 2k >> sql 2k8: text, ntext and image

Question

Post reply

sql 2k >> sql 2k8: text, ntext and image

maryamzolfaghar

Ten Centuries

Points: 1211
More actions
April 24, 2012 at 5:10 am

#273099

What happens when I upgrde from sql2k to sql2k8 for text, ntext and image columns?

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Lowell SSC Guru Points: 323482 More actions · Answer 1

the data types remain as they were.

the data types text, ntext and image are still valid data types, but it is recommended to change them to the newer types like varchar(max),nvarchar(max), and varbinary(max);

they are much easier to work with, due to advances in the code and engine; you can use things likesubstrings, and appending stings togheter much easier than with a TEXT field.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Eugene Elutin SSC Guru Points: 59322 More actions · Answer 2

Nothing!

But it is recommended to use varchar(max), nvarchar(max) and varbinary(max) instead.

_____________________________________________
"The only true wisdom is in knowing you know nothing"
"O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
(So many miracle inventions provided by MS to us...)

How to post your question to get the best and quick help[/url]

Grant Fritchey SSC Guru Points: 397721 More actions · Answer 3

The others are 100% correct. Nothing happens to those data types. But, to be sure what is going to happen to your databases when upgrading from 2000, you should run the Upgrade Advisor. It's a free download from Microsoft. It will let you know if there are issues with your 2000 databases.

----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software

maryamzolfaghar Ten Centuries Points: 1211 More actions · Answer 4

Thanks a lot for your advice

There was a warning on "Data Transformation Services"

Now, I checked what I had in "Data Transformation Services" >> "Meta Data Services Packages"

I removed all the objects there, since they were testee ones. Now there are no objects there, but I still get a warning from the upgrde advisor which says "Existing Meta Data Services Packages should be moved to SQL Server storage (in the msdb database) ..."

And it names them (the removed packages) in a list which says "Upgrade advisor may be unable to scan a package ..." {Although they are already removed)

Can anyone help?

Sean Lange SSC Guru Points: 286562 More actions · Answer 5

If you have no DTS packages you want/need to migrate then don't worry about it. The packages you don't want/need will not be created. If that is your only warning you should be good to go. You are going to do this on a test box with a backup right??????? Test it out, then have a few apps hit your new test db and make sure everything is good to go.

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

maryamzolfaghar Ten Centuries Points: 1211 More actions · Answer 6

maryamzolfaghar

Ten Centuries

Points: 1211

April 30, 2012 at 9:52 pm

#1481589

Many thanks to you 🙂