In March (CFDJ, Vol.3, issue 5) we covered reasons to upsize your Access
database to SQL Server and the tools you'll use to do it. Here we explain in
detail how to copy data to SQL Server and troubleshoot your upsizing project.
The IMPORT AND EXPORT data wizard (aka the DTS Wizard - Data Transformation
Services) certainly helps get you going with building tables in SQL Server.
It takes an Access database (as well as many other database types) to import
its table structures and data to a Microsoft SQL Server. Since it uses a
wizard format, it's simple to use as long as you know what data you want to
transform. To start the wizard choose START > MSDE > IMPORT AND EXPORT DATA
or START > Microsoft SQL Server 7.0 > IMPORT AND EXPORT DATA.
On the first data-gathering screen (see Figure 1) you'll be prompted for
information about the data source. Choose Microsoft Access from... (more)
If you're using ColdFusion with Access today, then it's likely you'll be
using it with SQL Server tomorrow. Luckily, Microsoft has provided some tools
that make upgrading to SQL Server a relatively easy process. You'll be
surprised to learn how simple it is to upgrade and how easy it is to work
This article covers the basics of using these tools and helps you plan an
easy database upgrade. You'll learn when and how to upgrade, and how to work
with the Microsoft Access 2000 "front end" to SQL Server to make your
transition as painless as possible.
Knowing When to Upgrade
Many of us have used the CFCONTENT tag that comes with ColdFusion to serve up
files to browsers, but very few ColdFusion developers are aware that the
CFCONTENT tag can be used in conjunction with the HTML tag to serve up
graphics, such as JPEGs and GIFs. In this case, the why of doing this is
perhaps just as interesting as the how.
It turns out that using this technique is perfect for use with creating an
advertising banner server, controlling access to graphic files, or - on the
more sinister side - creating "Web bugs."
If you don't recall, a Web bug is a graphic (usually... (more)
One of the most common database-driven applications on the Internet is the
Internet forums are used for product support, organizational announcements,
and corporate discussion areas, and as a place to talk about the theme of a
given Web site. They're popular because they offer a convenient way to
discuss interests and ideas while keeping a sense of history - something a
typical e-mail list doesn't have. They also have the advantage of offering
site administrators a high level of control over what's being talked about
and how it's discussed.
If you've been cons... (more)
If you have used any content management systems or any of the popular
Web-based e-mail portals, you've probably had an opportunity to use something
like eWebEditPro. The idea behind this product is to make it easy for anyone
to write HTML-enhanced content right on a Web site.
When the user goes to type text, instead of a regular bland HTML