473,473 Members | 1,805 Online
Bytes | Software Development & Data Engineering Community
Create Post

Home Posts Topics Members FAQ

Migration from PostgreSQL

2 New Member
I have to migrate a current PostgreSQL database to MSSQL. But the binary format returned by PostgreSQL is in octal reprensentation.

So, Is there a simple way to convert (import) all the data for PostgreSQL to MSSQL, with a wizard (ie: OLE or ODBC), a free tool, etc, to a format understand by MSSQL.

Otherwise, I have thought to use BULK INSERT, but I do not know the format of the binary data used by this statement, is it OCTAL or HEXADECIMAL ??

Thanks

Note : Sorry for my english, it is not my first language.
Mar 8 '08 #1
0 1060

Sign in to post your reply or Sign up for a free account.

Similar topics
5
mass migration from mysql?
by: Mike Henley | last post by:
considering the recent changes to the mysql licensing terms, which meant the php5 team had to adopt sqlite instead into the php5 and drop mysql stuff from the standard language distro (as i...
Latest Bytes
0
FmPro Migrator 1.97 for MacOS X and Windows - Adds FileMaker to PostgreSQL Migration Feature
by: David Simpson | last post by:
..com Solutions Inc. has released FmPro Migrator 1.97 Enterprise Edition with a new FileMaker to PostgreSQL migration feature. Images within FileMaker container fields are automatically migrated to...
Latest Bytes
0
mysql to pgsqwl migration
by: K. Suresh | last post by:
Hello, I have a database application with Java and PHP clients. I used mysql with 64 tables. Now, we have decided to use pgsql. Please suggest the migration procedure. Thanks. Suresh
Latest Bytes
3
Oracle to PostgreSQL migration
by: Randy Harris | last post by:
I've been scouring the PostgreSQL web site and have found several references to a Database Migration Wizard. I was unable, however, to find any details. Would someone be kind enough to explain...
Latest Bytes
7
Migration to Postgres
by: Hank | last post by:
As a background task, I am migrating our back end from Access 2000 to PostgreSQL. It is important to me that the front end code runs on both Access and PostgreSQL to ease the pain on the day we...
Latest Bytes
1
Migration from mysql to postgresql
by: shrini | last post by:
Friends. I want to migrate from mysql to postgresql. I have a lot of databases and tables in mysql. I can export them. I need your guidance for importing the databases into postgresql.
Latest Bytes
1
Migration from SQL Server to PostgreSQL
by: Shrikant S Kulkarni | last post by:
Hello All One of our clients is at very initial stage of migration from SQL 2000 to PostgreSQL. It’s not been finalized and some research is going on. Since I am new to PostgreSQL, I don't have...
Latest Bytes
0
Saii
PostgreSQL to Oracle migration
by: Saii | last post by:
Hello Can somebody point me to a good document on PostgreSQL to Oracle migration steps. I have checked various sites including postgresql.org but I need to have a basic head start to evaluate the...
Latest Bytes
1
Help for Data Migration
by: lion cave | last post by:
hi, I'm using postgreSQL and php. I am assigned for migration of data of database. I would like to ask a help if how to migrate the data from the Postgre 8.0 to the Postgre 8.3. Is there...
Latest Bytes
0
marktang
What is ONU?
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
Latest Bytes
0
Changing the language in Windows 10
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
Latest Bytes
1
The easy way to turn off automatic updates for Windows 10/11
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
Latest Bytes
0
tracyyun
Discussion: How does Zigbee compare with other wireless protocols in smart home applications?
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
Latest Bytes
1
isladogs
Access Europe - Using VBA to create a class based on a table - Wed 1 May
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...
Latest Bytes
0
Couldn’t get equations in html when convert word .docx file to html file in C#.
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
Latest Bytes
0
Trying to create a lan-to-lan vpn between two differents networks
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...
Latest Bytes
0
muto222
php
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
Latest Bytes
0
bsmnconsultancy
Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...
Latest Bytes

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.

BYTES.COM © 2024
About Bytes
Terms Of Use
Privacy Policy
Sitemap
Advertise on Bytes
How to Post and Respond on Bytes
How to Promote and Link on Bytes
How to increase your Ranking on Bytes
Become a Recognized Expert on Bytes
Feedback Welcomed! Contact Us