How to add tables to SQL 2005 database.

How do I get another table into my database? I have a table with data on my local machine and would like to get it into my database. I've scripted the table and put the structure into my database, but have not been able to get the data into it. Thanks.

Post Edited (jhunter) : 7/13/2008 11:56:38 AM GMT

 

Which SQL Server aware products are you using locally?
I can provide step by step instructions once I know what you're using.
i.e. Full version of SQL Server 2005, SQL Server 2008 Express, etc.
Salute,
Mark

 

SQL Server 2005 Express.


Microsoft SQL Server Management Studio Express9.00.3042.00
Microsoft Data Access Components (MDAC)2000.085.1132.00 (xpsp.080413-0852)
Microsoft MSXML2.6 3.0 4.0 5.0 6.0
Microsoft Internet Explorer7.0.5730.11
Microsoft .NET Framework2.0.50727.1433
Operating System5.1.2600

 

Hi,
If you upgrade to the new express version, 2008, you can use the Import/Export wizard.
With SQL Server 2005 Express you need to use the Generate Scripts method:
http://blog.sqlauthority.com/2007/08/21/sql-server-2005-create-script-to-copy-database-schema-and-all-the-objects-stored-procedure-functions-triggers-tables-views-constraints-and-all-other-database-objects/

Once you generate the scripts for the table and records you then, in 2005, connect to your DASP server.
Open a new query window and past the scripts in there then execute them.
Make sure you alter the first few lines, i.e. database name.

You can just take the database name out on your DASP account the server will resort to the default.
All you'll need to do is run the script parts for the actual tables and records.

I blogged about SQL Server 2008 Express not long ago, it really is going to simplify this for guys:
http://blogcastrepository.com/blogs/wisemx/archive/2008/06/12/sql-server-2008-express-rc0.aspx
Salute,
Mark

PS - If you get stuck I can do this for you, no problem.

 

I haven't seen that problem, you might want to use their forums, maybe someone can give a few tips.

 

I finally got SQL 2008 Express Advanced installed. I can connect to my database, but can't see any ofmy tables. Do you have any ideas about what the problem might be, besides being unfamiliar withthe new version?

 

I've uninstalled and reinstalled SQL Server 2008 Express Advanced (RC0) several times and get the following error:
TITLE: Microsoft SQL Server 2008 Setup
------------------------------
The following error has occurred:
The MOF compiler could not connect with the WMI server. This is either because of a semantic error such as an incompatibility with the existing WMI repository or an actual error such as the failure of the WMI server to start.
For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=10.0.1442.32&EvtType=Microsoft.SqlServer.Configuration.Sco.WmiProvider.InstallMof%2540Microsoft.SqlServer.Configuration.Sco.ScoException%25401211%25401
------------------------------
BUTTONS:
OK
------------------------------

I'm installing only the Dataase Engine Services and the setup process fails. I can't find anything on the MS about this error. Do you have any idea about why I'm running into so many roadblocks?

 

Sorry, no idea, but I do suggest you post in the Microsoft forums.
They respond pretty quick and do want to know about this sort of thing.