MOVing To SQL 2005 on Crystaltech.com

I have spent the last 2 months or so designing and modeling my new application backend in SQL Server 2005 Express edition.

I am ready to move it to a production copy of SQL Server 2005.

How do I go about this?

What kind of words can I put into google to bring some sort of results.

I have been looking in many places but no luck on how to take all the tables I have made (some with data, some not) and copy them to a live SQL 2005 Server.

Thanks in Advance for any help.

When I right-click on the Database in the Manager, I choose Tasks..

But Import / Export options are NOT THERE.

What do I do?

Why is this option not in my instance of SQL Express.

Thank you.

|||Depending on how you want the database hosted you could use detach/attach, backup/restore or scripting of schema and data.|||

How can I produce a schema? I'm assuming that is what I need to do. I am moving the database from my local machine (SQL Server Express) to a hosted SQL Server 2005 machine.

Thank you for your help,

Jon

|||You would need to write a few lines of code that call SMO.|||Jon,
I am in the same boat with my Express db. I have signed up with CrystalTech for hosting. Did you find a good solution to your problem?

Greg Lamb

Moving to hosted dedicated server - Cannot open database requested in login

Hello all,
I hope someone can help with my current issue as i have now spent the last 8hours trying to solve it! Here goes...
I am currently moving all my websites from our in house set up to a FASTHOSTSdedicated server. Our in house set up consists of separate server for weband data and works well even with my recent foray into .Net sites.
I have just moved the most recent of my .Net sites(http://www.alfadealerads.co.uk/home.aspx) to the FASTHOSTS server and cannotget the site to connect to the database (this has also been installed on theFASTHOSTS server). One of the pages that connects to the DB ishttp://www.alfadealerads.co.uk/links.aspx, where i am getting the error..
System.Data.SqlClient.SqlException: Cannot open database requested in login'MasseratiChauffeurDrive'. Login fails.
Login failed for user 'lateral'.
This DB has been restored from back up from the original DB. I haverecreated the user name on the new SQL server and added it to the new DBalso. I am using a webconfig to connect to the DB, the exact same onethat works on my current live server(http://www.maseratichauffeurdrive.com/home.aspx) only with the obvious changeto the SQL server name.
The only difference i can see in the 2 setups is that the new one has both thewebserver and the SQL server on the one machine and that machine uses domains.
My current in house setup does not use domains and as mentioned before web anddate are 2 separate servers.
Can anyone help? Or even understand what the hell i have written? lol
Thanks in advance

I know the backup and restore wizard can restore everything including login so the question is why do you have to recreate the login after the restore. I would do a fresh restore and delete the current database and try to login without any changes. Hope this helps.|||

TheFIsh wrote:

System.Data.SqlClient.SqlException: Cannot open database requested in login'MasseratiChauffeurDrive'. Login fails.
Login failed for user 'lateral'.
This DB has been restored from back up from the original DB. I haverecreated the user name on the new SQL server and added it to the new DBalso. I am using a webconfig to connect to the DB, the exact same onethat works on my current live server(http://www.maseratichauffeurdrive.com/home.aspx) only with the obvious changeto the SQL server name.

When you created the new login account, did you check the "SQL ServerAuthentication" radio button instead of leaving it on the default"Windows Authentication"?
|||Thanks for the feedback.
When you created the new login account, did you check the "SQL ServerAuthentication" radio button instead of leaving it on the default"Windows Authentication"?
Yes i checked the SQL server authentication and specified a password. Still not solved.
Cheers,
Stephen