Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Phasma Felis
Starting Member
1 Post |
 Posted - 2006-04-09 : 03:05:42
|
| We're in the process of changing from a Windows-based to a Linux-based server, and among other things, we need to move our database from a remote-hosted Microsoft SQL server to a locally-hosted MySQL database. I'm connecting to the remote database with SQL Server 2005 Trial Edition. (I believe our provider is still using SQL Server 2000.)The local MySQL software is not set up yet on the new server, and I'm trying to figure out how to do the move once it's ready. I've played with the import/export wizard in SQL Server, but when I try to export the database in any format, I get this error:- Validating (Error)MessagesError 0xc00470fe: Data Flow Task: The product level is insufficient for component "Destination - AccessLevels" (25). (SQL Server Import and Export Wizard) Error 0xc00470fe: Data Flow Task: The product level is insufficient for component "Data Conversion 1" (43). (SQL Server Import and Export Wizard)I think this is saying that my version of SQL Server doesn't have export capability. I'm not sure why that should be, as the Trial Edition "has a comprehensive set of SQL Server 2005 features", according to Microsoft's website, unlike the more limited Express Edition. I'm a bit of a novice with SQL, and I'm not sure what to do next, short of copying 68 tables by hand. Can this be done with the software I have? If not, it there an alternative?Thanks for your help. |
|
|
|
|
|
Exporting from MS SQL Server to MySQL