So your original plan was to change from 2 HDD's on the Primary IDE Port plus two opticals on the Secondary IDE, to two HDD's again on the Primary IDE (but a 1 TB SATA via adapter replacing the old 250 GB IDE), and one or two (depending on what works) opticals. One optical = new SATA DVD-RW unit via adapter, and possible second being the old IDE CD-RW unit.
Now, however, we have a couple more alternatives. Regarding HDD's, you can choose NOT to remove the old 250 GB IDE unit and simply add the new 1TB unit via a real SATA port and cables. On the optical front, you can proceed as planned above, OR you could leave your two old units in place and add the third one on the second SATA port, but you are missing a SATA cable.
You have not mentioned it, but a SATA unit needs TWO connections - one 7-conductor ribbon cable for data (to mobo) plus one 15-conductor power supply line from the PSU. If you do not have power supply SATA connectors coming from the PSU, you can get adapters to power them from 4-pin Molex outputs.
Now, your plan was to keep the old 30 GB unit as the boot drive with Win XP SP3 installed on it, and merely upgrade the 250 GB data drive to a 1 TB unit. Is that still your plan? hang-the-9 was advising a wholesale change involving a complete re-install to a single 1 TB HDD. If that appeals to you, let us know. Or, if you find the 30 GB unit is getting crowded as your C: drive and want something bigger, you also could shuffle things so that the 250 GB unit takes over as your C: drive you boot from. Does that appeal?
I'm going to advise assuming you want:
(a) keep both old HDD's and add the 1 TB as a SATA device for data only;
(b) replace the old CD unit with the new DVD-RW unit (a SATA device plus an adapter). Note I said replace the CD, not the CD-RW. Don't know why you said you wanted to keep the CD, but if you do that makes little difference for what I recommend.
1. Disconnect power, open case, leave your two old HDD's connected as they were. Disconnect the new DVD-RW and re-connect both the older optical drives as they were.
2. You MIGHT have a problem getting your mobo's SATA controller (VERY likely to be original 1.5 Gb/s SATA) to work with a newer SATA 3.0 Gb/s (aka SATA II) HDD. The way to force that new drive to slow down to older settings is shown in this WD web page:
http://wdc.custhelp.com/cgi-bin/wdc.cfg/php/enduser/std_adp.php?p_faqid=981&p_created=1052339456&p_sid=VyJ_Tvak&p_accessibility=0&p_redirect=&p_srch=1&p_lva=&p_sp=cF9zcmNoPTEmcF9zb3J0X2J5PSZwX2dyaWRzb3J0PSZwX3Jvd19jbnQ9NjQsNjQmcF9wcm9kcz0yODgsOTUmcF9jYXRzPTEyMyZwX3B2PTIuOTUmcF9jdj0xLjEyMyZwX3BhZ2U9MQ!!&p_li=&p_topview=1#satadesktopjump
NOTE the first diagram of jumper settings for SATA 3.0 Gb/s units. Place one jumper on pins 5&6 to force to 1.5 Gb/s. You may NOT need this - the drive is supposed to figure it all out and automatically set itself. BUT sometimes that fails and you have to install the jumper.
3. Now connect the new SATA HDD to the first SATA port on the mobo (and its power). Close up, reconnect power cord, turn on power and use the F2 key to enter BIOS Setup. On the first screen with drives you should see all your old units - 2 HDD's and 2 opticals - normally. Tab to other screens and find the one where SATA ports are configured. Find the line for SATA ports and make sure they are Enabled. Nearby you should find a place to set SATA Port Mode. Set that to IDE (or PATA) Emulation, and NOT to RAID. Save and Exit, and it will finish booting up. Everything will look like it did before. You will NOT see the new HDD in My Computer.
4. Click on Start ... Control Panel ... System and choose the Hardware Tab, then the Device Manager button. Expand the optical device line to see your two drives there. For each of them, RIGHT-click and choose to Uninstall. When done, back out of this and shut down. Open up and disconnect both old optical units. This will remove all optical drive units so you can start fresh.
5. With no optical drives connected, reboot into Windows. Now we'll set up the new HDD using Disk Manager. Click on Start, RIGHT-click on My Computer and choose Manage from the mini-menu. Expand Storage if necessary and click on Disk Manager. On the right you will see two panes. Each of them scrolls so you can see all they contain. The upper one will show you the drives Windows can use now - only your two old ones. The LOWER RIGHT pane will show you these a little differently, plus the new 1TB unit. RIGHT-click on that and choose from the menu to Create a new Primary Partition. That starts a Wizard where you set several options. Size: you want it to be as large as it allows (all of the capacity in one drive) I presume. You do NOT need this to be bootable - it is a data storage unit only. It should be Active. IF you see parameters for Formatting, set File System to be NTFS. You can do a Quick Format that will take 10 to 15 minutes. OR you can choose a Full Format which will do the same job and then take MANY HOURS to test absolutely all of the HDD for Bad Sectors (not common on a new HDD, but it happens!) if you have the time. Run the task. Now, IF you were using an earlier version of the Wizard you will NOT have seen Format options. In that case the task done first will only have Created the Partition. Then you would have to RIGHT-click again on that new Partition and choose to Format it, with options as above. Then run that as a second task. When done, back out of Disk Management and reboot. You should find your HDD in My Computer now, ready to use.
6. Now back to the optical units. If you are going to use one of your adapters to connect the new SATA DVD-RW unit to the Secondary IDE port, do that now. Connect only this drive for now - we'll get it running cleanly and then add the older optical drive after. Remember that this adapter insists it is the port Master, so connect it to the END of the data cable. Close up and boot up, and hopefully Win XP will detect a new device and find / install the driver it needs. If it has any trouble, do you have a driver for this new device on a CD or from its maker's website? Once that's done you should see the unit in My Computer, and be able to put a disk in it and read its files. Shut down and open case.
7. OK, now the second optical drive (one of your older ones). CHANGE its jumper - it probably is set to CS, and it MUST be set to Slave (the other unit is Master). Then reconnect, close up and boot up. Again, Windows should detect it and install the required driver. You should be able to see it and use it in My Computer.
8. Now, odds are the letter names for all these drives are not what you want. You can set that back in Disk Management's LOWER RIGHT pane again. I expect that the boot drive C:, and your old 250 GB HDD as D:, is OK. You probably have several applications and icons that depend on having a particular letter associated with one of the optical drives and will want to re-establish that name. You may also want to adjust the letter names for the other optical and for the new 1 TB unit. For each one you can RIGHT-click on the drive in the LOWER RIGHT pane and choose to Change its Name. BUT you cannot use a letter already used by something else. So you will need a two-step process. Rename one with a letter you want to re-assign (E: for example) as something out of the way, like "P:". Now, with E: freed up, assign that to the drive that you want to be E:. Similarly, set F:. Lastly, rename P: to G:. Or whatever - you get the idea. When you have them all the right way, back out and reboot again so Windows can update its Registry. My Computer should have five drives now - three HDD's including your new one, plus two opticals including the DVD-RW, all ready to use.
9. You intended to migrate ALL of the files on your 250 GB IDE unit to the new 1 TB unit and then to remove the older 250 GB unit. You nay have re-thought that plan now that you can have all three drives in use. BUT if you still want to migrate the data, the best tool is a free cloning tool from your 1 TB unit's manufacturer, WD. Go to their website and download a utility called Acronis True Image WD Edition. It is a VERY good and powerful utility that does a lot more than cloning, so be sure you get the manual and read it. Install it on your C: drive. Run it, go to the menus for cloning, and be VERY careful to set up the first two options. Set the SOURCE to your 250 GB older unit, and make SURE to set the DESTINATION to the new 1 TB unit. If necessary, tell it to delete any Partition on the DESTINATION drive. By default it will plan to make the clone copy the same size as the source (250 GB), but that it not what you want. Find the menu choice to set your own size on the DESTINATION drive, and make it what you really want - probably the entire 1 TB disk. The cloned disk does NOT need to be bootable, and it will need the NTFS File System. You may have the Quick vs. Full Format option to choose, too. Run the job and it will copy absolutely everything from the old 250 to the new 1 TB unit, including all hidden files, etc. It will leave all those files on the old HDD, too. But after you are confident that the new one is working fine, you can re-assign the 250 GB unit for something else. In fact, what I suggest is that you use Disk Management to rename the units so the 1 TB becomes your D: drive, and the 350 GB unit becomes G: or whatever.
10. AFTER you have done the migration above you have a 250 GB IDE unit available for use. You could use Disk Management to Delete its Partition and then Create a new Partition and Format that, giving you an empty storage HDD. Or, you could clone your old 30 GB drive to the 250 GB unit, remove the 30 GB unit, and plug the 250 GB unit in as the boot drive on the Primary IDE Port. However, that Acronis utility you got for free from WD's website will make a clone TO a WD disk unit only. So if your 250 GB unit is made by somebody else, you'll need to find another cloning utility to do this.