P.S. Tasks > Export

Hot Topic

RAISEERROR from CLR stored procedures
Where to begin?
SQL Server pricing
(Repost) Problems installing SQL 2005 Express after trying VS.NET 2005 Beta 2
This SMO transfer script doesnt transfer ?
Upgrade msdb database from CTP April build
removing duplicate rows
Visibility of a matrix column base on parameter selection
File Connector w/ Execute Package Task Expression Bug?
Custom Sql Exceptions through the CLR

SQL Server

Need help in grouping ....
URGENT : Failed to run snapshot agent ?
Can SSIS package be run from WebService?
How to add and give roles to users in RS via web service?
Sql Reporting Services problem
How to not import a text file twice
Failure saving package
SQL Server 2005 uninstall problem
Persistent BI Studio Crashes
RSExecutionLog_Update.dtsx error!!

P.S. Tasks > Export

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.

Answer this question

P.S. Tasks > Export

  • Gabriel Mendez

    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

  • Jimig

    You would need to write a few lines of code that call SMO.

  • Johnny P

    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

  • Cha Chunchadatharn

    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.

  • antonioa - msft

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

  • P.S. Tasks > Export
Answer this question