Tomi NA wrote:
> On 2/16/06, Matt <mat..ogicsquad.net> wrote:
>>
>>
>> Tomi NA wrote:
>> > I'd like to transfer table structure and _data_ from a source mssql
>> > database
>> > to a postgresql database.
>> > Has anyone here tried something like this? I have a feeling parts of
>> > cayenne
>> > code might be of help, but it's hard to think clearly after straight
>> 16
>> > hours of staring at the screen...any suggestions would be very
>> welcome.
>> >
>>
>> Hello,
>>
>> have you considered just dumping the structure and data, and inserting
>> it
>> into postgres, outside of cayenne?
>>
>> # mysqldump -u username -p password database_name > file.sql
>>
>> edit out you mysql badness
>>
>> # psql -d myDataBase (-a) -f file.sql
>>
>
> That's the problem with names like mssql and mysql: they get mixed up
> really
> easily. Who ever came up with a name like SQL Server for RDBMS?!
> Anyway, there's no simple way to dump structure and data from a MSSQL
> database...well, actually, there is, but I have a 50MB script on my hands
> now, which is very hard to work with (modify the syntax so that pgsql
> doesn't complain about it)...and that still doesn't adress the finer
> aspects
> of the transition (object name case management, for one).
>
> Tomislav
Aah.. my apologies!
Matt
This archive was generated by hypermail 2.0.0 : Wed Feb 15 2006 - 22:35:10 EST