SQL

---

Moving from Access to SQL?

This entry was posted in Development Software Tips and tagged Access Mysql Oracle SQL SSMA Sybase on October 17, 2012 by HAL

Most users of access who have upsized their app to SQL will be familiar with the various wizards in the recent releases that facilitate data transfer to SQL Server. However sometimes this approach won’t work. A client recently came to me with an issue relating to an older access database which used data access pages […]

---

2 useful Oracle resources

This entry was posted in Storage Tips and tagged Oracle PL/SQL SQL on June 7, 2012 by HAL

If you are learning about SQL or specifically Oracle and SQL / PLSQL – here are two useful resources – good to refresh your memory also if like me its been a while. The links are shown in blue below The PL/SQL link is here – an article entitled “Building with Blocks” Oracle Magazine SQL 101 […]

---

Database backup using ftp

This entry was posted in Software Tips and tagged FTP SQL on January 26, 2012 by HAL

Most admins will have used or set up ftp servers to facilitate transfer of data between machines. A colleague mentioned seeing  a utility that combined backing up ms sql data and the use of an ftp server as the destination for the backup. The utility he had seen was SQL BACKUP and FTP from http://sqlbackupandftp.com/. There […]

---

---