data insertion problem
-
Hello everyone, i need help regarding data import, i m using SQL Server 2000 i have a database in which i have diagrams,
Data, and views and SPs, now i make a new database on MSDE and add as a new instance in SQL Server 2000, now i want to import the complete db to MSDE Db, but when i used the import method it import the tables but not created the relationship. e.g. Primaryket and Foreign Keys , so me using script take script and run on MSDE db, but its only make tables structure not inserted data, now me using import method to insert data only but its take time to import data as its give me error if i added data in the FK table first, and during importing it add data and insert IDs in the IDs column , but i see in some tables it start inserting data e.g 5, the next id is 7 and 9 then start the 10,11,12... identity, and is some table let say Student i have data in Student ID: 1,2,5,8,9... but when i import data from i db to
other db it gives the student id: 1,2,3,4,5....... so when i import data Courses so in that table i have studentid as a foreign key (with values : 1,2,5,8,9) and it inserted newd identity Ids, so gives errora during importing, so i have to maunally set the data.so in overall this procedure makes me exhausted,plz help me how i import data , as if i used the 3rd part tool when i get the data and insert it in the tables then PK and Fk issues comes so its also take time to set tables data first insert PK's table data then FK's table's data.
plz give me the simply and easy way to insert data, as in some cases we have already created a new DB so data insertion is the task , as if i want to make new DB to MSDE me using the DB backup, but when the above case comes then what can i do/
reply me and give me idea or any way to insert data easily.
Thanx in Advance.
-
If you want to copy an entire database with all schema, keys, and data,... why not just do a restore from a backup???
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply