From the course: Migrating Access Databases to SQL Server

Unlock the full course today

Join today to access over 22,400 courses taught by industry experts or purchase this course individually.

Exploring the results in SQL Server Management Studio

Exploring the results in SQL Server Management Studio

From the course: Migrating Access Databases to SQL Server

Start my 1-month free trial

Exploring the results in SQL Server Management Studio

- Now that the migration is complete, let's take a look at what happened inside of SQL server management studio. I'm going to go ahead and expand the databases folder here, and we'll find the Kinetico Migration Wizard database. Now this one should be the one that we've copied our data tables into from Access, so if I expand the tables, sure enough, here we go. I've got the Customers table, Employees, Orders, Products and States. If I right click on one of these tables, and choose Select Top 1,000 Rows, I'll expect to see some data. And indeed, I do see that data. Now one of the things that didn't happen is these fields here, this customer ID. In Access, it was an auto-incrementing number, and what I want to do is make sure that that change happens inside of SQL server as well, so I want to change this Customer ID to an identity field. to do that, let's go ahead and close this panel here, I'll right click on Customers, and then we'll choose this design here in order to edit the table's…

Contents