Using PGNP with MS SQL Server, Data Transformation Services (DTS), SQL Server Integration Services (SSIS), Linked Servers, Snapshot and Transactional Replication and more.
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.
- Posts: 2
- Joined: Fri Jul 02, 2010 5:30 am
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.
- 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