Migrating Microsoft SQL Server database on OCI to Oracle Database with Oracle SQL Developer

Oracle SQL Developer is a free, integrated development environment that simplifies the development and management of Oracle Database in both traditional and cloud deployments. At some point, you might encounter a project or client requires you to access Microsoft SQL Server from your Oracle Cloud Infrastructure (OCI) Windows virtual machine (VM) or your own desktop.

If you’re new to using Microsoft SQL on OCI, we provide a blog series that teaches you to about the exciting technical offerings that Oracle provides. If you plan to bring your Microsoft SQL servers to OCI, you can start learning more in this blog post. We also have a QuickStart tutorial, Connect to Microsoft SQL Server database on Oracle Cloud Infrastructure using Oracle SQL Developer.

Before we cover the capabilities of the primary tool, Oracle SQL developer, while accessing the Microsoft SQL Server database, let’s understand the major specifications of Oracle SQL Developer.

Oracle SQL Developer

Oracle SQL Developer is one of the native tools that Oracle offers to manage Oracle databases on a single platform. It offers complete end-to-end development of PL/SQL applications, processing of all types of queries, data modelling, and migration of third party databases to Oracle. To learn more, see SQL Developer.

If you’re a PL/SQL or SQL Developer, this tool is for you. Developers can run all kinds of complex select queries, views, and stored procedures to complete their day-to-day job. An admin user can create, truncate, drop tables, and create stored procedures and views on this tool.

If you’re looking to collate metadata of the tables, this tool enables you to accomplish tasks easily.

If you want to export the metadata of any table, SQL Developer can also help you with that.

You can migrate tables with data from Microsoft SQL Server to an Oracle database connected on the same Oracle SQL Developer using the following guide. Oracle uses this method to bring important value to multienvironment database support.

Conclusion

You can utilize Oracle SQL Developer for many purposes on OCI in the realm of Microsoft SQL Server databases. For Microsoft SQL Server databases, you can accomplish multiple tasks, including connecting to Microsoft SQL Server databases, writing and running SQL queries, and migrating Microsoft SQL Server tables to an Oracle database with a few keystrokes. Begin your journey with OCI with a Free Trial.

Stay tuned for our next blog for SQL Server on Oracle Cloud Infrastructure.