Impact of Database Migration/Update..

I

iDenTiTy

Expert Member
Joined
Apr 14, 2007
Messages
3,899
Reaction score
2
Location
Fourways (vicinity)
Impact of Database Migration/Updating..

Hi guys.

I was thinking last night:

What advantages does say, SQL 2008 provide over say SQL 2000?
If there are any advantages, what would the costs be (financial, technical) of migration?

For those with big databases: Just how huge are the problems you would encounter?


The only experience I have is exporting a MySQL db into Access (as odbc) and then export as ODBC in order to import into SQL Server 2008.
So my experience is VERY SMALL w.r.t the subject above.

:o
 
Last edited:
Very easy, Backup database in SQL2000, Restore it in SQL2008
 
iDenTiTy said:
But if you were to do it, what are the things you have to (carefully) consider?
Click to expand...

- Is my hard disk big enough for the backup file? :)

The SQL database engine hasn't changed that much from 2000->2005->2008. What has changed is all the bells and whistles that go with the database engine.

Data Transformation Services has been replaced with SQL Server Integration Services, so any DTS packages need to be rewritten.

SQL 2008 backup model has changed, so you need to redesign your back strategy.

Those sorts of things have changed, but ultimately it's still a SQL database server.
 
Deenem said:
- Is my hard disk big enough for the backup file? :)

The SQL database engine hasn't changed that much from 2000->2005->2008. What has changed is all the bells and whistles that go with the database engine.

Data Transformation Services has been replaced with SQL Server Integration Services, so any DTS packages need to be rewritten.

SQL 2008 backup model has changed, so you need to redesign your back strategy.

Those sorts of things have changed, but ultimately it's still a SQL database server.
Click to expand...

Rings true to the tune of SQL is SQL is SQL then.

:D

Cool.

What interested me though was the nice-ities that came with 2008.

It is a bit somewhat a nuisance that 2008 is so sluggish, when I ran 2000 it was so much faster.

:rolleyes:

Dunno why, but I find MySQL slightly 'easier', faster.
Though, 2000 is far easier/familiar than 2008 to me.

:o


Thanks for the input guys.

:)
 
iDenTiTy said:
What does MSSQL offer over and above that of DB2?
IS DB2 that far behind MSSQL?

:confused:
Click to expand...

It's faster, easier to maintain and cheaper. You also have the benefit of CLR (in 2005+) and you can have longer SQL statements and more columns per select statement.

That's my experience of it though...
 
If you currently have an MS SQL database stick with MS. They use a slightly different sql language.

Migration might go smootly or not depending on the complexity of both your front-end and database. The best and easiest way to find out would be to download a trial version of 2005/2008 and test it extensively.
 
You must log in or register to reply here.
Back
Top
Sign up to the MyBroadband newsletter
X