Re: OT - moving data from mssql to mysql

If you can use the sql enterprise manager, you should be able to get the SQL to rebuild the tables (it won't be 100% compatible, but it's a start) right click on a table, choose 'all tasks', then 'generate sql scripts'. it'll walk you thru the process, and ask you for a filename to export them to. if the account isn't active tho (legal problems?) you may have issues doing that, which is the only way I know how to do it. :( HTH Brett wrote: > sorry about the off topic post. I was hoping some of you guys would have an opinion. > > I recently picked up an account that was previously hosted on NT. They used a mssql 7.0 > database. The site owners are in legal disputes with the previous designers. > > I need to get the structure and values out of the mssql so I can use the same values in a mysql > database and to get an idea of how their current database is setup. Does anyone have an idea of the > best way to get the information from the mssql database. I was able to get a dump of the mssql, but > the filename is a .dmp and my editors are not currently able to read the dump. Please help if you > can. > > Thanks, > Brett > brett@atlantanights.com -- ========================== Michael Kimsal http://www.tapinternet.com 734-480-9961