Exporting Tables from SQLExpress 2005 to SQLExpress 2005

Hi,

I just installed the latest version of VWD 2005 Express Edition and the latest version of SQL Express Edition 2005 and noticed that some stored procedure in the ASPNETDB.MDF file have been implemented.

When I use my ASPNETDB.MDF file from the Beta 2 release, in the latest version, I cannot connect using my login info to the database... I receive an error message that the stored procedure is "to long.....".

As I already created more than 35 Tables, I would like to export the tables and import them back in SQL Express 2005 (latest version) so that I don't need to create them again...

Do I really need to install SQL 2005 Standard Edition to have the Enterprise Manager do the job ? Is this not included in the SQL Server Management Studio Express ?

Thanks to all of you out there.....
B.The import/export functionality uses SSIS, which is not included in SQL Server Express. Because SSIS is not included in SQL Server Express and functionality that depends on it would always be broken when working with Express servers, we removed anything that relied on SSIS from Management Studio Express.

You could use the Generate Scripts Wizard to generate scripts for the tables you would like to copy to the new database. You can get to this by right clicking on a database in Object Explorer and selecting Tasks > Generate Scripts...

This only re-creates the table metadata, so you would have to write some T-SQL to move the data in the tables.|||Had similar problem, but was able to solve by copying the SPs from the VWD release version of aspnetdb.mdf to the VWD beta version. Thus, no need to reconstruct anything in the web site. Had it not worked, I would have had to delete aspnetdb.mdf, allow VWD to create a new one and then re-enter all the data in the tables.
I ran into three changed SPs (there may be more) and was able to copy/paste all of them with success. I decided that having a 'bastardized' version of aspnetdb was an acceptable solution. Other problems may yet emerge since this is not a deployed web site.
Bob|||

It’s a little disappointing that SQLExpress does not have the ability to import data or tables from other applications especially since if you look at the feature comparison for the various versions of SQL 2005 it does indicate the SQLExpress does have that feature.

http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx I’ve also had trouble with the books online even after following all the requirements and recommended fixes. If this is any indication of the rest of the product line I’m glad I haven’t convinced my boss to upgrade.|||The document you point to does seem to have an error regarding the ability of Express to perform Import/Export. I will submit a change request to have that document updated to be accurate. The remainder of the document appears to be correct.
If the Import/Export wizards or other SSIS functionality is a primary requirement for you, you should definitely look at one of the Editions of SQL Server 2005 that includes this functionality. If you only have a limited amount of data to import or export, you could consider using a tool such as BCP. There is more information about the BCP utility available at http://msdn2.microsoft.com/en-us/library/ms162802.aspx.
Regards,

Mike|||

There is another free product from MS called "Web Data Administrator" which will perform Import/Export on MSDE/Express databases.|||I try to install "Web Data Administrator" but you need to have IIS installed.

You can use the free Microsoft "SQL Server Management Studio Express" to generate scripts and then execute it into the production server.

You can download it at: http://msdn.microsoft.com/vstudio/express/sql/default.aspx|||Actually there is not an error in the doc it just needs better explained, BCP and Linked Servers can both be used to import and export data, there is just no gui for them, thats what the row refers to.