How does one generate Transact-SQL for table structure in SQL server express 2005?
I have very limited access to an SQL server database (using rudimentary web based interface) for my hosted website. I am ready to deploy an application that was developed with Visual Studio 2005 using SQL server express as the database. I have four tables that I want to copy (structure only) from "express" to the hosted SQL server. I think I need to generate Transact-SQL statements to "create" the table structure, then run these statements as a stored procedure on the web based SQL server. I'm having trouble trying to figure out how to generate the code from SQL express 2005. Anyone had any experience with this?
thanks.
Try the link below download and install the eval version as a named instance then register the Express, how right click at the top of management studio and you can generate the create table statement or do an INSERT INTO. Run a search for INSERT INTO and how to register a server in the BOL(books online). Hope this helps.
http://www.microsoft.com/sql/downloads/trial-software.mspx
No comments:
Post a Comment