Can PGNB support view script export?

Using PGNP with MS SQL Server, Data Transformation Services (DTS), SQL Server Integration Services (SSIS), Linked Servers, Snapshot and Transactional Replication and more.

Can PGNB support view script export?

Postby Jimmy Huang » Fri Jul 02, 2010 5:39 am

Hello, I am newbie to use PGNB, I want to export my mssql2008 database to postgresql database, I export the general tables data successfully, and when I tried to export views, the PGNB just created real tables for each view. Is it possible to export views as sql script rather than real tables?
I am using the trail version 1.3.
Jimmy Huang
 
Posts: 2
Joined: Fri Jul 02, 2010 5:30 am

Re: Can PGNB support view script export?

Postby Moderator » Sat Jul 03, 2010 10:34 pm

Currently it is not supported, but potentially the support can be added. How many views do you want to export? Would it be hard to do manually?

If you are going to do the database transformation regularly, then consider creating SSIS package in BIDS. The package can perform the regular tables transformation in Data Flows, and views creation can be done as SQL Tasks.
User avatar
Moderator
Site Admin
 
Posts: 310
Joined: Wed Oct 29, 2008 11:27 pm


Return to SQL Server/DTS/SSIS/Linked servers/Replication

Who is online

Users browsing this forum: Bing [Bot] and 1 guest

cron