Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
thiemebr
Starting Member
2 Posts |
 Posted - 2009-11-11 : 11:27:21
|
| Here is the situation.The company I work for, uses a MRP software (Material Requirements Planning) which use a MS SQL 2000 DB. Prior to SQL it was an access DB which was converted to a SQL db.Sometime ago, the DB server crashed and we needed to reinstall everything in a new server.We restored the SQL backup but the tables structure for some reason has been changed. Now it is missing PKey for example. This MRP software has a tool to create a blank DB on SQL with all structures needed, PKey etc. When I create this blank DB and import the data, the SQL import the data and the tables structure.How can I import only the data from a DB to another without changing anything else?ThanksThieme |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2009-11-11 : 11:49:36
|
Give this a try:Start SQL Server Enterprise Managerconnect to your server with that new created Databaseright click on that database and choose -- all task -- import... and step through the wizard (with open eyes).
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
|
|
|
Export to .TXT file and Importing back