Can PGNB support view script export?

  • Jimmy Huang
  • Topic Author
  • Visitor
  • Visitor
13 years 9 months ago #296 by Jimmy Huang
Can PGNB support view script export? was created by Jimmy Huang
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
13 years 9 months ago #299 by Moderator
Replied by Moderator on 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.133 seconds
Powered by Kunena Forum