October 7, 2002 at 4:14 am
Hi all,
I'm to upgrade my sql 7 to sql 2000. will the upgrade affect my dts and scheduled tasks? Or is there any precaution to take when doing the upgrade?
Thanks
Rgds,
scyeo
October 7, 2002 at 4:20 am
and what about the trigger?
Rgds,
scyeo
October 7, 2002 at 5:42 am
Really nothing to worry about with any of those. Do a good backup first, then upgrade. As easy as it gets.
Andy
October 7, 2002 at 8:21 pm
The only issue we ran into when upgrading from SQL Server 7.0 to SQL Server 2000 was that we were using the word Function (and we still are) as a column name. SQL Server 7.0 didn't care, however SQL Server 2000 wouldn't let us use it until we put the word function in brackets like this: [Function].
So unless you think you are using any reserved words as column names you should be fine. And even if you are, I would still upgrade. Either put the brackets around questionable column names before or immediately after. Also, even though the words First and Last are always highlighted in blue in the Query Analyzer, they don't cause any problem as column names.
Robert Marda
SQL Server will deliver its data any way you want it
when you give your SQL Programmer enough developing time.
Robert W. Marda
Billing and OSS Specialist - SQL Programmer
MCL Systems
October 7, 2002 at 9:35 pm
Thank you very much
Rgds,
scyeo
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply