Porting SQL Server 2000 database to PostgreSQL

Поиск
Список
Период
Сортировка
Искать
От
REarly@jswcoinc.com (Rod Early)
Тема
Porting SQL Server 2000 database to PostgreSQL
Дата
в 02:05:03
Msg-id
9f928ea6.0405200654.f534664@posting.google.com
Список
Дерево обсуждения
Re: Porting SQL Server 2000 database to PostgreSQL anony@dslextreme.com (anony)
Re: Porting SQL Server 2000 database to PostgreSQL Robert Treat <xzilla@users.sourceforge.net>
I have the task of converting a SQL Server 2000 database to
PostgreSQL.  The data itself does not need to be converted, but the
structure and stored procedures must be.

I expect that converting tables and views will be simple.  I expect
that converting stored procedures and user-defined functions from
T-SQL to PostgreSQL will be more complex.

In any case, I am looking for recommendations and counsel regarding my
expectations.  I have much Windows 2000/NT and SQL Server experience,
and some Unix/Linux experience, probably post-beginner level.  (I used
to work with Unix and VMS all the time in college 15 years ago but
haven't touched it since.)

I plan to use a Windows client such as pgAdminIII to administer and
work with the database in PostgreSQL.  The database is used by a
WindowsCE application, so I will need to change its data access layer
from SQLClient to whatever is needed in CE and Windows to access
PostgreSQL.

Thank you in advance for your recommendations, advice, warnings,
gripes, etc.

Rod Early
В списке pgsql-general по дате отправления
От: Nick Allan
Дата:
Сообщение: Problem with public schema
От: NTPT
Дата:
FAQ