Can PGNB support view script export?

More
10 years 1 month ago #296 by Jimmy Huang
Jimmy Huang created the topic: Can PGNB support view script export?
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.

Please Log in or Create an account to join the conversation.

More
10 years 1 month ago #299 by Moderator
Moderator replied the topic: Re: Can PGNB support view script export?
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.

Please Log in or Create an account to join the conversation.

Time to create page: 0.068 seconds
Powered by Kunena Forum