SQL Server 2022 in Preview

On November 2, 2021, Microsoft announced the preview of SQL Server 2022, the most Azure-enabled release of SQL Server yet, with continued innovation in performance, security, and availability.

The rise of data represents a tremendous opportunity and also poses challenges. Companies are seeing their relational and nonrelational data proliferate exponentially on-premises, in the cloud, at the edge, and in hybrid environments. The most transformative companies drive predictive insights on current data, whereas others may struggle to drive even reactive insights to their historical data. Information may be siloed across geographies and divisions.

To learn more, click here

Import data from Microsoft Access to SQL Server

Microsoft has made importing data from Access much easier using Access 2007 or above than previous versions. Running SSIS packages or using the Import/Export wizard seemed time consuming and often would error out requiring more troubleshooting than it’s worth. I’m using an Access database with two tables named Customers and Orders for this post:

SQL Freelancer SQL Server Microsoft Access IntegrationFirst, make sure all tables are closed within in our Access database or we’ll get an error:

SQL Freelancer SQL Server Microsoft Access IntegrationOnce all tables are closed navigate to Database Tools | SQL Server as shown below:

SQL Freelancer SQL Server Microsoft Access IntegrationAfter clicking SQL Server an Upsizing Wizard dialog box should appear. Since I don’t have a database created I will click “Create New Database” option as shown below.

SQL Freelancer SQL Server Microsoft Access IntegrationIf there was already a database in place clicking “Use existing database” will bring up a few screens to setup a data source to a preexisting database. After clicking next, we need to enter some information to connect to our SQL Server and create our database. When specifying the Login ID make sure this user has CREATE DATABASE permissions on the server. For this example I will use SQL2008 for my server and create a database called Bama:

SQL Freelancer SQL Server Microsoft Access IntegrationClick here to view the rest of this post.