PDA

Click to See Complete Forum and Search --> : Changing an Access Database to sql or Oracle

ed7890
June 15th, 2005, 03:37 AM
I have an Access Database and i have to change it to sql or Oracle to meet some IT requirements. Could any tell me if this is very difficult. I understand sql but i've never created a database in it.

Could anyone suggest anywhere i could find help for either sql or Oracle, which one you think would be best, or any development software you think would i should get.

Thanks
Shuja Ali
June 15th, 2005, 03:42 AM
In SQL Server, you can use Data Transformation Services to import the database from Access to SQL along with the data.. It is not too difficult, a wizard in Enterprise Manager will help you through to do this.. You just need to slect options and the data will be tranferred to SQL server

I am not sure about Oracle..
ed7890
June 15th, 2005, 04:15 AM
I have to meet pretty tight restrictions on my database though. i'd prefer to start afresh in sql than to trust it to transfer over correctly. is it hard to work with sql? is all written with code?

Also, what are clusters?
Shuja Ali
June 15th, 2005, 05:52 AM
I have to meet pretty tight restrictions on my database though. i'd prefer to start afresh in sql than to trust it to transfer over correctly. is it hard to work with sql? is all written with code? It depends on how much experience u hav wid SQL.. No you don't have to do everything with code, you could use Enterprise Manager to create tables, etc. No need to write codes and everything is done by clicking on menus/options/shortcuts.. :)
I still don't understand why you can't import the access database in to SQL, it will be much more easier than creating a new database..

Also, what are clusters?

Also called an "allocation unit," it is some number of disk sectors that are treated as a unit. This is the smallest unit of storage the operating system can manage. For example, on a PC with a 200MB hard disk, the smallest cluster is eight sectors (8 x 512 bytes) or 4K. On a 2GB disk, the cluster is 32K. That means a 1K file takes up 32K on the disk, wasting an inordinate amount of space. In mid-1996, the Windows 95 that came with new PCs (Win95B) introduced the FAT32 32-bit file allocation table which decreased the cluster size to 4K.