| From: | "Chris Mair" <list(at)1006(dot)org> |
|---|---|
| To: | <deepak(dot)sharma(at)bersoftinfotech(dot)com> |
| Cc: | <pgsql-advocacy(at)postgresql(dot)org> |
| Subject: | Re: urgent query |
| Date: | 2006-06-12 14:19:28 |
| Message-ID: | 41753.193.206.186.101.1150121968.squirrel@www.endian.it |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-advocacy |
> i want to migrate my database made in SQL server 2000.i tried this with
> the transformation wizard available in SQL server 2000.i've successfully
> export the tables from my SQL server 2000 database to PostgreSQL
> database.but the stored procedures were not imported.
>
> so please tell me how could i migrate complete database including
> tables,stored procedures,user functions etc
SQL server's TransactSQL and PostgreSQL's PL/pgsql are quite different
languages. It won't be as easy as using a wizard to translate between the
two. I'm afraid you'll have to rewrite your procedures.
The PL/pgsql docs can be found here:
http://www.postgresql.org/docs/8.1/static/plpgsql.html
Bye,
Chris.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Markus Schiltknecht | 2006-06-12 18:46:16 | database contest in c't (German IT magazine) |
| Previous Message | Deepak | 2006-06-09 06:39:44 | urgent query |