Thread: MSSQL to PostgreSQL
Hello, what is the current status of the MSSQL to PostgreSQL tools/tips? Google returns results as old as 2001... The MSSQL database in question has only tables, no stored procedures, etc. Thanks, Iv
Iv Ray wrote: > Hello, > > what is the current status of the MSSQL to PostgreSQL tools/tips? > > Google returns results as old as 2001... > > The MSSQL database in question has only tables, no stored procedures, > etc. > > Thanks, > Iv > Hi Ray, I have something that does this. I am currently awaiting project approval on pgfoundry. It does tables, views, and stored procedures. I have tested it on 450,000 lines of mssql code including 400 tables and 3700 stored procedures, although it is a work in progress. I applied last week and they said it takes 72 hours. As soon as it is approved I can post it. (give it a couple days I guess) Gwyneth
> Hi Ray, > > I have something that does this. I am currently awaiting project > approval on pgfoundry. > It does tables, views, and stored procedures. I have tested it on > 450,000 lines of mssql code > including 400 tables and 3700 stored procedures, although it is a work > in progress. > > I applied last week and they said it takes 72 hours. As soon as it is > approved I can post it. > (give it a couple days I guess) > > Gwyneth Hi Gwyneth, sounds very interesting. We found this - http://wiki.postgresql.org/wiki/Converting_your_data_from_MS_SQL_Server_7_to_PostgreSQL_7.1.x (for very old version) - it is surprising that the SQL Enterprise Manager does this... We gave it a little try today and saw that indeed, there is "PostgreSQL" in there. But we left to try it tomorrow. Do you know it? We do not have stored procedures, only tables and views. Would be, in any case, interested in seeing what you have. Iv
Iv Ray wrote: >> Hi Ray, >> >> I have something that does this. I am currently awaiting project >> approval on pgfoundry. >> It does tables, views, and stored procedures. I have tested it on >> 450,000 lines of mssql code >> including 400 tables and 3700 stored procedures, although it is a >> work in progress. >> >> I applied last week and they said it takes 72 hours. As soon as it is >> approved I can post it. >> (give it a couple days I guess) >> >> Gwyneth > > Hi Gwyneth, > > sounds very interesting. > > We found this - > > http://wiki.postgresql.org/wiki/Converting_your_data_from_MS_SQL_Server_7_to_PostgreSQL_7.1.x > > > (for very old version) > > - it is surprising that the SQL Enterprise Manager does this... We > gave it a little try today and saw that indeed, there is "PostgreSQL" > in there. But we left to try it tomorrow. Do you know it? > > We do not have stored procedures, only tables and views. Would be, in > any case, interested in seeing what you have. > > Iv Ray, I think we tried that and I think it works but not for us. It may work for you. MS wants to copy all the tables over with exactly the same names including [dbo]. and so on. When it doesn't find an exact match, it wants to create the table. This may be ok for you but I am not sure what it does about mapping datatypes. This is controlled in my program by precreating the tables with the desired mappings. (we have mostly found what works but it can be changed easily) We have over 400 tables and as they are related, they need to be loaded in a particular order. I control this with a file of table names (dropped out of the conversion program) The data copy is only a few scripts largely based on FreeTDS. (do a google, I won't post a link here) So give the Enterprise Manager a try. It may work for you. I think we only had to install a Postgres odbc driver. My program(s) should be available soon (few days I figure) when I get a place to post it. Gwyneth
Gwyneth Morrison wrote: > Ray, > > I think we tried that and I think it works but not for us. It may work > for you. > > MS wants to copy all the tables over with exactly the same names > including [dbo]. and so on. > When it doesn't find an exact match, it wants to create the table. This > may be ok for you but > I am not sure what it does about mapping datatypes. This is controlled > in my program by precreating the > tables with the desired mappings. (we have mostly found what works but > it can be changed easily) > > We have over 400 tables and as they are related, they need to be loaded > in a particular order. > I control this with a file of table names (dropped out of the conversion > program) > > The data copy is only a few scripts largely based on FreeTDS. (do a > google, I won't post a link here) > > So give the Enterprise Manager a try. It may work for you. I think we > only had to install a Postgres odbc driver. > > My program(s) should be available soon (few days I figure) when I get a > place to post it. > > Gwyneth Sounds reasonable what you say. We will give Enterprise Manager a try tomorrow, and if it does not work for us, I will hope your tool will be published soon. Funny, that there isn't such a tool yet. Iv