How can I migrate an existing Access database to SQL Server?
Microsoft SQL Server is the database solution of choice for small- and large-scale sites alike. Many developers often start out with Access as their database solution, but quickly realize the advantages of the more robust and scalable SQL Server. As a result, they spend time migrating their Access database to SQL Server. If you’re planning on doing just that, the Microsoft Access Upsizing Tool will help. This tool provides a clear path to SQL Server 7. (Or so I hear, anyway.) http://www.microsoft.com/accessdev/prodinfo/aut97dat.htm Microsoft Access Upsizing Tool http://www.sqlmag.com/Articles/Index.cfm?ArticleID=6133 When you upsize make sure SQL doesn’t change any fields to ntext as Cold Fusion can’t deal with them. Also make sure that all date fields are datetime and not small date time as when you import the data you may ge a data overload for some of the rows. I had this problem when transfering from Paradox and Interbase db’s. One piece of advice I would give is to use the data im
Related Questions
- If a customer already owns Microsoft SQL Server or uses Oracle databases, can they use their existing database software with iGrafx Process Central?
- I uninstalled MONAHRQ 1.0 and installed MONAHRQ 1.1. Why am I unable to connect to the existing database in SQL Server that I used in MONAHRQ 1.0?
- How can I migrate an existing Access database to SQL Server?