export data from postgresql on linux to ms-sqlserver 2000 on windows

Nishy

Hello all,

I have been trying to find some information about exporting data from
postgresql on linux to ms-sqlserver 2000 on windows but have not been
able to get hold of any information. I would really appreciate if
someone can point me to some source of information.

Thanks in advance,
Nishy

Nov 11 '05 #1

Subscribe Post Reply

1657

Chris M

Maybe you can use MS SQL Server's DTS. You can find this
application in SQL Server's program group from Start Menu.

DTS can tranport data using ODBC, OLEDB, etc.
You may try to export data from postgresql by ODBC.

Nov 11 '05 #2

Phoenix

Probably be a lot easier to pull the data from PostGreSQL into SQL Server
since I have had a hell of a time finding a DBD for SQL Server ;-)
"Nishy" <ni*******@hotmail.com> wrote in message
news:16**************************@posting.google.c om...

Hello all,

I have been trying to find some information about exporting data from
postgresql on linux to ms-sqlserver 2000 on windows but have not been
able to get hold of any information. I would really appreciate if
someone can point me to some source of information.

Thanks in advance,
Nishy

Nov 11 '05 #3

Similar topics

Export to Excel

by: Matt | last post by:

I have an ASP page that calls ASP routines that I created that execute a database query and return the results to a recordset. I then iterate through the recordset and display the data in a table....

ASP / Active Server Pages

access xp postgres data from linux

by: Mike Ballard | last post by:

I run an xp program in vmware that uses a postgresql db. I want to back up this db from linux. The cmd I was given to backup the db from within xp is: pg_dump.exe -i -h <server> -p <port> -U...

PostgreSQL Database

Excel 97 Export to Postgres

by: Raymond | last post by:

Need to export an existing M$ Access 97 database to Postgres. Tuples must be filtered as I am using sequences and other constraints. Help from anyone that has experience with this or know of...

PostgreSQL Database

Replication again

by: Chris M. Gamble | last post by:

Does anyone know a good commercial application that does multi-master replication for postgres? Thanks ---------------------------(end of broadcast)--------------------------- TIP 2: you can...

PostgreSQL Database

Postgresql on file system EXT2 or EXT3

by: Carmen Wai | last post by:

Hello: I would like to know whether there is any different in installing Postgresql on the Linux system with file system of EXT2 or EXT3. I have two machines with idential OS (Red Hat 7.3...

PostgreSQL Database

Backup and Export

by: David | last post by:

I am a little confused by DB2 Backup and Export. I used "db2 backup db QAS to /dev/rmt0" backuping 650GB database to a IBM LTO 3581 (1 drive) only 11 hours. But I used "db2 export to /dev/rmt0...

DB2 Database

postgresql + apache under heavy load

by: Alex Madon | last post by:

Hello, I am testing a web application (using the DBX PHP function to call a Postgresql backend). I have 375Mb RAM on my test home box. I ran ab (apache benchmark) to test the behaviour of the...

PostgreSQL Database

Data Encryption in PostgreSQL, and a Tutorial.

by: Mike Cox | last post by:

Has anyone created something like that for Postgresql? It would be really handy to encrypt credit card numbers and other information so it stays secure. If no one has created anything such as...

PostgreSQL Database

import/export or moving data between databases

by: Iavor Raytchev | last post by:

Hello, We a situation with a central database that contains the data that needs to be presented at N off-line terminals (N can be 5 000 can be 15 000). Each terminal presents unique data. The...

PostgreSQL Database

Export to Excel (Default File Type - Excel)

by: Hemant Sipahimalani | last post by:

The following piece of code is being used to export HTML to excel. HttpContext.Current.Response.ContentType = "application/vnd.ms-excel"...

ASP.NET

React to native button blinking effect

by: lllomh | last post by:

Define the method first this.state = { buttonBackgroundColor: 'green', isBlinking: false, // A new status is added to identify whether the button is blinking or not } autoStart=()=>{

Software Development

How to find best mobile app development company in usa

by: Aliciasmith | last post by:

In an age dominated by smartphones, having a mobile app for your business is no longer an option; it's a necessity. Whether you're a startup or an established enterprise, finding the right mobile app...

Mobile Development

Can faster file sharing be achieved by connecting computers simultaneously via WiFi and LAN cables

by: tracyyun | last post by:

Hello everyone, I have a question and would like some advice on network connectivity. I have one computer connected to my router via WiFi, but I have two other computers that I want to be able to...

Networking - Hardware / Configuration

Energy Model code modification to account for year dependent interest rate

by: giovanniandrean | last post by:

The energy model is structured as follows and uses excel sheets to give input data: 1-Utility.py contains all the functions needed to calculate the variables and other minor things (mentions...

Python

Send Current Object to PDF

by: NeoPa | last post by:

Hello everyone. I find myself stuck trying to find the VBA way to get Access to create a PDF of the currently-selected (and open) object (Form or Report). I know it can be done by selecting :...

Microsoft Access / VBA

VBA Class Basics

by: NeoPa | last post by:

Introduction For this article I'll be using a very simple database which has Form (clsForm) & Report (clsReport) classes that simply handle making the calling Form invisible until the Form, or all...

Microsoft Access / VBA

Access Europe Meeting - Wed 1 Nov - Using SQL Server skills to extend Access

by: isladogs | last post by:

The next Access Europe meeting will be on Wednesday 1 Nov 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM) Please note that the UK and Europe revert to winter time on...

Microsoft Access / VBA

VBA Class Basics (Report Class)

by: NeoPa | last post by:

Introduction For this article I'll be focusing on the Report (clsReport) class. This simply handles making the calling Form invisible until all of the Reports opened by it have been closed, when it...

Microsoft Access / VBA

Access Europe Meeting - Wed 6 Dec - Streamline Your Import/Export Spec Workflow with VBA Classes

by: isladogs | last post by:

The next online meeting of the Access Europe User Group will be on Wednesday 6 Dec 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, Mike...

Microsoft Access / VBA