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 |
|
cluksha
Starting Member
2 Posts |
 Posted - 2010-08-31 : 09:39:58
|
| I have about two dozen VIEWS that I need to backwards engineer into tables on another system. I would do it by hand except that each view has at least 20-30 fields in it. The caveat - I am moving the structure from MSSQL to mySQL. Don't flame me for doing it please :) It has to be done.So I have SQL Server Manager Studio installed and only have access to the views and not the actual tables. I can seem to export to either ODBC or to mySQL. Nor can I seemingly create a SQL file to run.Does anyone know how I might get from A to D here ?Thanks and God Bless!ChrisChris LukshaEcho Web ServicesMaking Your Website Resound603-831-0099http://www.echowebservices.com/Send Your CAN-SPAM Compliant Email Newsletter for only $.05 per Subscriberhttp://www.echowebservices.com/email |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-08-31 : 10:00:21
|
| what error do u get trying to export? do u have permissions on both source and target? |
 |
|
|
cluksha
Starting Member
2 Posts |
Posted - 2010-08-31 : 11:40:22
|
| It would seem it is a permissions issue of some kind..TITLE: Microsoft.SqlServer.Smo------------------------------An exception occurred while executing a Transact-SQL statement.------------------------------ADDITIONAL INFORMATION:An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)------------------------------The SELECT permission was denied on the object 'sql_expression_dependencies', database 'mssqlsystemresource', schema 'sys'.The SELECT permission was denied on the object 'sql_expression_dependencies', database 'mssqlsystemresource', schema 'sys'.The SELECT permission was denied on the object 'sql_expression_dependencies', database 'mssqlsystemresource', schema 'sys'. (Microsoft SQL Server, Error: 229)I seem to have found a solution I think . . . I use Navicat for Mysql and it seems I can connect to the db and import from that. Thank you for the help.Chris LukshaEcho Web ServicesMaking Your Website Resound603-831-0099http://www.echowebservices.com/Send Your CAN-SPAM Compliant Email Newsletter for only $.05 per Subscriberhttp://www.echowebservices.com/email |
|
|
|
|
|
|
Copy tabl stucture from a view?