In this example, I am using SQL Server 2008 R2, but SQL Server 2005 is an option as well. Install or have access to SQL Server Enterprise or Standard edition.Install the Postgres OLE DB Provider on the machine where SQL Server Integration Services will run, because this will install a Postgres OLE DB provider.We will use this database to export data from the students table in Postgres to SQL Server with SQL Server Integration Services. In this example, the database used to import data is the 'Postgres' database which is installed by default. In this tip we will outline the steps to import a single table from Postgres to SQL Server with SQL Server Integration Services. Unfortunately, there is not too much information on the Internet about this topic. Sometimes it is necessary to migrate data from Postgres to SQL Server. ![]() ![]() By: Daniel Calbimonte | Updated: | Comments (17) | Related: More > Integration Services Development
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |