Colleagues,
Say, you have a huge number of tables in a database, all sitting on the Sequel 2000 server, with tons of SPs and whatnot.
You've gotta upgrade to a newer (not necessarily the newest ) version (say, 2010 or 2012).
So, you have this SQL 2010 installed/set up... All's fine and dandy, but the data's still on the old one.
Is there a way to transfer the database (with SPs, Triggers, all 9 yards) directly from Sequel 2K to 2010 one?
It's a question in general, coz if it's not possible - that'd be the end of it.
TIA!
Regards
Ilya
Regards,
Ilya
Say, you have a huge number of tables in a database, all sitting on the Sequel 2000 server, with tons of SPs and whatnot.
You've gotta upgrade to a newer (not necessarily the newest ) version (say, 2010 or 2012).
So, you have this SQL 2010 installed/set up... All's fine and dandy, but the data's still on the old one.
Is there a way to transfer the database (with SPs, Triggers, all 9 yards) directly from Sequel 2K to 2010 one?
It's a question in general, coz if it's not possible - that'd be the end of it.
TIA!
Regards
Ilya
Regards,
Ilya