--- title: "Loading Converted Database Objects into SQL Server (AccessToSQL) | Microsoft Docs" ms.prod: sql ms.custom: "" ms.date: "01/19/2017" ms.reviewer: "" ms.technology: ssma ms.topic: conceptual helpviewer_keywords: - "Access databases, loading converted objects into SQL Azure" - "Access databases, loading converted objects into SQL Server" - "data, securing" - "loading objects into SQL Azure" - "loading objects into SQL Server" - "migrating objects into SQL Azure" - "migrating objects into SQL Server" - "moving objects into SQL Azure" - "moving objects into SQL Server" - "schemas, loading into SQL Azure" - "schemas, loading into SQL Server" - "scripting converted objects" - "securing data" - "SQL Azure, loading objects into" - "SQL Server, loading objects into" - "synchronizing metadata with SQL Azure" - "synchronizing metadata with SQL Server" - "uploading objects into SQL Azure" - "uploading objects into SQL Server" ms.assetid: 4e854eee-b10c-4f0b-9d9e-d92416e6f2ba author: "Shamikg" ms.author: "Shamikg" --- # Loading Converted Database Objects into SQL Server (AccessToSQL) After you have converted Access database objects to [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] or SQL Azure, you can load the resulting database objects into [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] or SQL Azure. You can either have SSMA create the objects, or you can script the objects and run the scripts yourself. Also, SSMA lets you update target metadata with the actual contents of [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] or SQL Azure database. ## Choosing Between Synchronization and Scripts If you want to load the converted database objects into [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] or SQL Azure without modification, you can have SSMA directly create or recreate the database objects. That method is quick and easy, but does not allow for customization of the [!INCLUDE[tsql](../../includes/tsql-md.md)] code that defines the [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] or SQL Azure objects, other than stored procedures. If you want to modify the [!INCLUDE[tsql](../../includes/tsql-md.md)] that is used to create objects, or if you want more control over objects creation, use SSMA to create scripts. You can then modify those scripts, create each object individually, and even use [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] Agent to schedule creating those objects. ## Using SSMA to Synchronize Objects with SQL Server To use SSMA to create [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] or SQL Azure database objects, you select the objects in [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] or SQL Azure Metadata Explorer, and then synchronize the objects with [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] or SQL Azure, as shown in the following procedure. By default, if the objects already exist in [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] or SQL Azure, and if the SSMA metadata has some local changes or updates to the definition of those very objects, then SSMA will alter the object definitions in [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] or SQL Azure. You can change the default behavior by editing **Project Settings**. > [!NOTE] > You can select existing [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] or SQL Azure database objects that were not converted from Access databases. However, SSMA will not re-create or alter those objects. **To synchronize objects with SQL Server or SQL Azure** 1. In [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] or SQL Azure Metadata Explorer, expand the top [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] or SQL Azure node, and then expand **Databases**. 2. Select the objects to process: - To synchronize a complete database, select the check box next to the database name. - To synchronize or omit individual objects or categories of objects, select or clear the check box next to the object or folder. 3. After you have selected the objects to process in [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] or SQL Azure Metadata Explorer, right-click **Databases**, and then click **Synchronize with Database**. You can also synchronize individual objects or categories of objects by right-clicking the object or its parent folder, and then clicking **Synchronize with Database**. After that, SSMA will display the **Synchronize with Database** dialog, where you can see two groups of items. On the left side, SSMA shows selected database objects represented in a tree. On the right side, you can see a tree representing the same objects in SSMA metadata. You can expand the tree by clicking on the right or left '+' button. The direction of the synchronization is shown in the Action column placed between the two trees. An action sign can be in three states: - A left arrow means the contents of metadata will be saved in the database (the default). - A right arrow means database contents will overwrite the SSMA metadata. - A cross sign means no action will be taken. Click on the action sign to change the state. Actual synchronization will be performed when you click **OK** button of the **Synchronize with Database** dialog. ## Scripting Objects If you want to save [!INCLUDE[tsql](../../includes/tsql-md.md)] definitions of the converted database objects, or you want to alter the object definitions and run scripts yourself, you can save the converted database object definitions to [!INCLUDE[tsql](../../includes/tsql-md.md)] scripts. **To save one or more objects to a script** 1. In [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] Metadata Explorer, expand the top node (the server name) and then expand **Databases**. 2. Do one or more of the following: - To script a complete database, select the check box next to the database name. - To script or omit individual views, expand the database, expand **Views**, and then select or clear the check box next to the view. - To script or omit individual tables, expand the database, expand **Tables**, and then select or clear the check box next to the table. - To script or omit individual indexes for a table, expand the table, expand **Indexes**, and then select or clear the index. 3. Right-click **Databases** and select **Save as Script**. You can also script individual objects. To script an object, regardless of which objects are selected, right-click the object and select **Save as Script**. 4. In the **Save As** dialog box, locate the folder where you want to save the script, enter a file name in the **File name** box, and then click **OK**. SSMA will append the .sql file name extension. ### Modifying Scripts After you have saved the [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] or SQL Azure object definitions as a script, you can use [!INCLUDE[ssManStudioFull](../../includes/ssmanstudiofull-md.md)] to modify the script. **To modify a script** 1. On the [!INCLUDE[ssManStudio](../../includes/ssmanstudio-md.md)] **File** menu, point to **Open**, and then click **File**. 2. In the **Open** dialog box, locate and select your script file, and then click **OK**. 3. Edit the script file by using the query editor. For more information about the query editor, see "Editor Convenience Commands and Features" in [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] Books Online. 4. To save the script, on the File menu, select **Save**. ### Running Scripts You can run a script, or individual statements, in [!INCLUDE[ssManStudioFull](../../includes/ssmanstudiofull-md.md)]. **To run a script** 1. On the [!INCLUDE[ssManStudioFull](../../includes/ssmanstudiofull-md.md)] **File** menu, point to **Open** and then click **File**. 2. In the **Open** dialog box, locate and select your script file, and then click **OK**. 3. To run the complete script, press the **F5** key. 4. To run a set of statements, select the statements in the query editor window, and then press the **F5** key. For more information about how to use the query editor to run scripts, see " [!INCLUDE[ssManStudioFull](../../includes/ssmanstudiofull-md.md)] [!INCLUDE[tsql](../../includes/tsql-md.md)] Query" in [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] Books Online. You can also run scripts from the command line by using the **sqlcmd** utility, and from [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] Agent. For more information about **sqlcmd**, see "sqlcmd Utility" in [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] Books Online. For more information about [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] Agent, see "Automating Administrative Tasks ( [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] Agent)" in [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] Books Online. ## Securing Objects in SQL Server After you have loaded the converted database objects into [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)], you can grant and deny permissions on those objects. It is a good idea to do this before migrating data to [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)]. For information about how to help secure objects in [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)], see "Security Considerations for Databases and Database Applications" in [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] Books Online. ## Next Step The next step in the migration process is [migrate data into SQL Server](migrating-access-data-into-sql-server-azure-sql-db-accesstosql.md). ## See Also [Migrating Access Databases to SQL Server](migrating-access-databases-to-sql-server-azure-sql-db-accesstosql.md)