Database Migration

Networking/Security Forums -> Databases

Author: wickerandvineLocation: alang-alang Mandaue PostPosted: Sun Jan 06, 2008 6:19 am    Post subject: Database Migration
    ----
Hi,

How do I migrate database from MS SQL 7 to MS SQL 2000?

Tnx

Author: GroovicusLocation: Centerville, South Dakota PostPosted: Sun Jan 06, 2008 2:22 pm    Post subject:
    ----
Doesn't Microsoft provide a migration tool?

Author: wickerandvineLocation: alang-alang Mandaue PostPosted: Mon Jan 07, 2008 6:46 pm    Post subject:
    ----
I don't know if microsoft is providing a migration tool.

Author: GroovicusLocation: Centerville, South Dakota PostPosted: Mon Jan 07, 2008 6:52 pm    Post subject:
    ----
I am not familiar with Microsoft SQL, but can't you just make a backup of the data and restore it in the other database?

Author: wickerandvineLocation: alang-alang Mandaue PostPosted: Fri Jan 11, 2008 7:16 am    Post subject:
    ----
I already tried backing it up and restoring it in SQL 2000 but it did not work.

Author: obake PostPosted: Sat Jan 26, 2008 6:01 am    Post subject:
    ----
did you try detach/attach the database?
There are few possible issues but you should be able to use this method to migrate your old database to a newer server.

Google will bring you tons of information, here is one link that might help:
[url]http://msdn2.microsoft.com/en-us/library/ms189625.aspx[/url]

Author: EricaRowletLocation: US PostPosted: Thu Sep 04, 2008 9:49 am    Post subject:
    ----
Theres a database migration tool exports structures and data tables of large database file and convert into MySQL server format efficiently and quickly. Database file convertor can either overwrites or create new destination database. Data migration tool needs no change in attributes, indexes, and keys values when identical records coverts into relational database table records. Utility have interactive GUI and run on windows OS.

This version is the first release on CNET Download.com.

Author: wonn1377Location: usa PostPosted: Wed Aug 19, 2009 4:01 pm    Post subject: Migrating almost any data
    ----
Data loader can help u, it can migrating almost any data, it helps me to convert MSSQL to MYSQL, MS access to MSSQL, mysql, csv loader, foxpro and MSSQL to MS access, MYSQl, CSV, foxpro etc. i found it on google search, In my view this is a best Data Migration Tool.

Download Free : http://www.dbload.com



Networking/Security Forums -> Databases


output generated using printer-friendly topic mod, All times are GMT + 2 Hours

Page 1 of 1

Powered by phpBB 2.0.x © 2001 phpBB Group