tolong..mana nak dpt perisian percuma nak convert data ms access ke sql ..dah cari pening..jumpa semua yg nak jual..Kalau tak da software..yg online convert ke..
3 posters
Tolong!!!3..Mana nak dapat freeware convert Ms access ke sql ??
kluanggirl- Ahli Baharu
- Gender : Male Number of posts : 25
Location : Dok Duane2 ah
Registration date : 18/07/2009
mikicun- Ahli Baharu
- Gender : Male Number of posts : 199
Location : somewhere i belongs...
Registration date : 15/02/2009
go here http://technet.microsoft.com/en-us/library/cc917601.aspx
or
taken from http://support.microsoft.com/kb/237980
or
taken from http://support.microsoft.com/kb/237980
The easiest way to convert an Access database to SQL Server is to use the Upsizing Wizard. The Upsizing Wizard:
* Preserves database structure, including data, indexes, and default settings.
* Automatically converts Access validation rules and default settings to the appropriate SQL Server equivalents.
* Maintains table relationships and referential integrity after you upsize.
To run the Upsizing Wizard in Access 2000, on the Tools menu, point to Database Utilities, and then click Upsizing Wizard.
To use the Upsizing Wizard in Access 97, you must first download the Microsoft Access Upsizing Tools 97 from the following Microsoft Web site:
http://www.microsoft.com/downloads/details.aspx?familyid=f5c7a907-7c5f-46cb-9157-a1ec4e96083d&displaylang=en (http://www.microsoft.com/downloads/details.aspx?familyid=f5c7a907-7c5f-46cb-9157-a1ec4e96083d&displaylang=en)
To run the Upsizing Wizard from Access 97, on the Tools menu, point to Add-ins, and then click Upsize to SQL Server.
If you have an earlier version of Access, you can use either one of the following methods:
* Upgrade to Access 97 or Access 2000, and then run the Upsizing Wizard.
* Use SQL Server Data Transformation Services (DTS) to import the data from your Access database to a SQL Server database. For more information about DTS and the DTS Import Wizard, see the "Data Transformation Services" and "Using the Import and Export Wizards" topics in SQL Server 7.0 Books Online. For an example, see the "Importing Data from an Access Database Example" topic in SQL Server Books Online.
If you are using Access 97 through Access 2003, together with SQL Server 2005, you can also use the SQL Server Migration Assistant for Access. For more information about the SQL Server Migration Assistant for Access, visit the following Microsoft Web site:
http://www.microsoft.com/sql/solutions/migration/default.mspx (http://www.microsoft.com/sql/solutions/migration/default.mspx)
kluanggirl- Ahli Baharu
- Gender : Male Number of posts : 25
Location : Dok Duane2 ah
Registration date : 18/07/2009
- Post n°3
okay tq
Nanti saya upgradekan access 2003 nie dulu, kalau ada pa2 saya tanya lagi.
dans kam- Ahli Baharu
- Gender : Male Number of posts : 172
Age : 42
Location : Wangsa Maju
Job/hobbies : PHP
Registration date : 19/02/2009
Guna MySQL Data Migration Wizard.
Tgk kat laman web MySQL.
Tgk kat laman web MySQL.