SQL Server Performance Forum – Threads Archive
exporting data from 7 to 2000
Hallo how can i upload data(only tables) from SQL 7 to ONLINE SQL 2000??? thanksYou can use DTS or EM, database, tables, right click, export. Luis Martin
Moderator
SQL-Server-Performance.com One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
Bertrand Russell
All postings are provided “AS IS†with no warranties for accuracy.
DTS is the best and easiest to do this. What about database upgrade wizard. have any body used it.
I used a couple of times, sometimes good sometimes complete desaster.
Luis Martin
Moderator
SQL-Server-Performance.com One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
Bertrand Russell
All postings are provided “AS IS†with no warranties for accuracy.
Luis,
Can you share the disaster situations for our knowledge please
http://msdn.microsoft.com/library/en-us/dtswizrd/dts_helpwiz_6lx5.asp
http://msdn.microsoft.com/library/en-us/dtswizrd/dts_helpwiz_4agj.asp
http://www.aldex.co.uk/dts.html Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
Dinesha: OS: NT4 SP6a.
SQL: 7.0 SP4 The idea was to install SQL 2000 and convert 1 customer database. The database size: 15GB. In the middle of installation SQL 2000 fail (no messages). After reboot we have nothing, no 7 nor 2000.
After severals tests, we have to remove all SQL 7, install SQL 2000 and restore databases. Luis Martin
Moderator
SQL-Server-Performance.com One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
Bertrand Russell
All postings are provided “AS IS†with no warranties for accuracy.
To avoid that type of disaster, why not run a full back-up of the db, and restore that under SQL 2000. The only stuff you would need to take care of would be logins and the old server being referenced from other servers.
To add to Adriaan:http://support.microsoft.com/default.aspx?scid=kb;EN-US;261334 —
Frank Kalis
Microsoft SQL Server MVP
http://www.insidesql.de
Ich unterstütze PASS Deutschland e.V. http://www.sqlpass.de)
Of course that was my suggestion, but the IT manager choose this way.
Luis Martin
Moderator
SQL-Server-Performance.com One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
Bertrand Russell
All postings are provided “AS IS†with no warranties for accuracy.
DTS is not a disaster recovery tool it only extends the feature of data import/export from other heterogenous data sources, if one is relying totally on DTS then it is nothing but risking the database itself. As suggested you can insist your customer to choose a better way than an easy way. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
]]>