
October 14th, 2004, 07:27 AM
|
|
Registered User
|
|
Join Date: Oct 2004
Posts: 3
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
|
Export/Display msSQL schema
g'day,
I'm very new to msSQL, and only diving into it for the sole purpose of transferring a system running on msSQL to MySQL :P. For testing I've used an export tool once, which could export my data as well as the schema to MySQL insert formats. Worked very cool. Did that from at one of my two bosses' home/office. Appearantly, his IP address is allowed to make connections and most others are not. Or at least, with the correct login username/password combi I cannot connect to the msSQL database server from anywhere else.
So, I was thinkinig - wouldn't it be cool if were to find some piece of ASP code I could just upload to the server, and use that to retrieve the database schema and data in a format I could read into MySQL. Nice thoughts, but my search for such a script has not yet produced any results.
And that is what brought me here. A last piece of hope for a solution. Any hints, tips, fully working scripts I can use to export the mssql database to MySQL.
Thanks in advance
(ps. php won't work, since the mssql_* functions are not available on the server)
|