by
Dr. Jayaram Krishnaswamy | April 2009 |
Microsoft
In this article by Dr. Jayaram Krishnaswamy, we will learn about migration of data from MS SQL Server 2008 to EnterpriseDB. Migration Studio bundled with the EnterpriseDB download is a collection of tools to migrate automatically the data and business logic into Postgres from a variety of vendor products that include SQL Server, Oracle, MySQL to mention a few. This article shows you step by step how you may migrate a SQL Server 2008 table to Postgres Plus. You can only migrate tables and schemas but not database as a whole.
With many database vendor products in the market and data intensive applications using them, it is often required to port the application to use the data or, migrate the data so that the application can use it. Migration of data is therefore one of the realities of the IT Industry. Some of the author's previous articles on migration can be found at this link. You may find more if you do a search on his blog site.
Table to be migrated in SQL Server 2008
The following figure shows the Categories table in the Microsoft SQL Server 2008's Management Studio that will be migrated to the Postgres database.
Creating a database in Postgres Studio
Right click Databases node in the Advanced Server 8.3 and click on New Database... menu as shown.
The New Database... window gets displayed as shown. Create an empty database PGNorthwind in Postgres Studio by entering information shown in the next figure.
This creates a new database and related objects as shown in the next figure.
This also creates the script in the Properties pane as shown. Review the properties. The database may be dropped using the Drop Database statement.
Starting the Migration Studio
Click on Start | All Programs | Postgres Advanced Server 8.3 to display the drop-down menu as shown.
Click on the Migration Studio drop-down item. This opens the EnterpriseDB Migration Studio 8.3(Migration Studio for the rest of the tutorial) with a modal form with the title Edit Server Advanced Server 8.3(localhost:5432). This is the server we installed in the previous tutorial.
Enter the User Name and Password and click OK. You will get a message displaying the result as shown in the next figure.
Click OK to both the open windows and the EnterpriseDB Migration Studio shows up as shown here.
Click on the File in the main menu on the Migration Studio and pick Add Server. This brings up the Add Server window with a default as shown.
Sign up for a Packt account to see the rest of this article
Now that you've read a few articles, you might want to consider signing up for a Packt account. It takes a matter of seconds, will give you access to all the articles on PacktPub.com, and once you've signed up you'll be returned here to carry on reading your article.
Furthermore, you'll gain access to nine free ebooks, and be offered a free trial of PacktLib, Packt's online library. Simply enter your details here, or log in to your existing account.
Post new comment