Re: Restoring SQL Databse for use in PostgreSQL.

Please keep replies copied to the list, so that other people can learn from
and help solve your problem.

Please don't top post.

On Mon, Feb 20, 2006 at 12:37:35 +0000,
Dhivya <dhivyacando(at)yahoo(dot)co(dot)in> wrote:
> Hi Bruno,
>
> Thanks for ur reply.
>
> I used SQL Server Enterprise Manager - Selected my Database - RightClick -All Tasks - Backup Database - Gave the location - Ok.
> Only when i create some database in PostGreSQL and right click that...i get the Restore Option to be enabled. There when i choose the file(that is to be backup), i did not get the OK button to be enabled.
> In PostgreSQL, i dont know how to restore the file.

This is really a SQL Server Enterprise Manager issue. I haven't used that
program and don't know what you need to do.

If worse comes to worse, if you can find the backup file you can probably
us it with psql or pg_restore depending on what kind of back up was done.

> Could you plz help me...
> Thanks in Advance,
> Dhivya.
>
>
> Bruno Wolff III <bruno(at)wolff(dot)to> wrote:
> On Fri, Jan 27, 2006 at 10:17:38 +0000,
> Dhivya wrote:
> > Hello,
> >
> > I am a new user to PostgreSQL.
> > I need to use the "Northwind" database in SQL.
> > I tried to take a backup of that database.
> > And tried to restore the backup in PostgreSQL. But i could not do that.
>
> How did you try to do that? What happened when you did?
>
> > And also when i try to display the columns of a table(in PostgreSQL) in a datagrid in the front end, the columns appears in random order(rather than the order in table (or) sorted).
>
> If you want the output ordered, you need to have an ORDER BY clause in your
> SELECT statement saying what to order by.
>
>
>
> ---------------------------------
> Jiyo cricket on Yahoo! India cricket
> Yahoo! Messenger Mobile Stay in touch with your buddies all the time.