How can i import records from a sql server table in project1 to another sql server table i

Hi, i have a table with all employee bio-data in a completed project. Iam now working on another project with a table that needs the same data and here iam talking about 300 records that rarely change. Instead of re-entering this data in this new table, i want to import the data from the completed project into a table in this new project. Does any one have any idea how to achieve that or is there a better option to do the same.

One more thing iam realising here is that iam going to use this same data in very many applications and some one from one department is going to enter this data in all these different applications. so i was wondering if there could be a way of having a central database that this guy can mantain and then i be able to use that table data in different applications that iam going to develop. I dont want to kill this unlucky guy with data entry tasks every time i deploy a new application.

So basically, how can make one database application sever several different applications with its data.

Why hold the database within the project at all? Move the database to the server, create one account for updating and one other applications that just need to read the data.

|||

You can share database for different projects. You can copy database tables from one database to another. Here is a sample for you to move one table from one database to another database without creating the new table first.

Run this from the database you want to export data:

SELECT*INTO newDataBaseName.dbo.yourNewTableFROM tableToExpost

|||

TATWORTH:

Why hold the database within the project at all? Move the database to the server, create one account for updating and one other applications that just need to read the data.

Iam running sql sever express 2005 with advanced services and visual web developer 2005 express edition. I also got info some where on msdn that sql sever express does not support multiple connections to a .mdf file. If this is true, then wont i run into error like

1. A connection can not be made, the file is being used by a nother process or application.

2. The database is closed.

|||

From http://msdn2.microsoft.com/en-us/library/ms345154.aspx#sseover_topic19

QL Server Express 2005MSDE 2000User Instance supportFeature not presentDTS in separate downloadDTS runtime presentEasy deployment because of no MDACMDAC is part of installMSI only, good servicing storyMSI and MSM, servicing of MSM hardSubscriber Replication for Transactional, Merge, and snapshotMerge/snapshot publication supported in addition to replication subscriptionRobust setup UIBasic setup UINo agentAgent presentSupports Windows 2000 SP4, Windows XP SP1, and Windows 2003Supports Windows 98, Windows Me, Windows 2000, Windows XP, Windows NT4, and Windows 2003CLR supportNo CLR supportGUI tools availableNo GUI toolsDatabase size limit: 4 GBDatabase size limit: 2 GB1 CPU, 1 GB RAM2 CPU, 2 GB RAMNo throttleWorkload throttle enforced for 5 concurrent workloadsDeep integration with Visual StudioBasic integration with Visual Studio

The phrase "No Throttle" implies that a given database can be used by more than one process.