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 |
|
marksquall
Starting Member
17 Posts |
 Posted - 2012-08-02 : 23:39:40
|
| Hello friends,A pleasant hello to everybody.Me and my friend is working in a simple Windows application (using C#) with some basic CRUD database to work on.We are using two different computer and each workstation has its own copy of installed SQL Server 2008.My friend already created two (2) tables (PERSON and STUDENT) with 50 records each, in his database named OURDB. Now I want to use his dummy data here in my computer, what is the SQL script (.sql file) I/we will do so that when I run the SQL script here in my computer, I will still get the 50 records of the two tables in my own copy of SQL Server 2008? I want to also include the relationship:PERSON has the primary key (ID) and STUDENT has the foreign key (ID).Thank you so much for the SQL script/syntax that you will teach.Thank you and more power!Warm regards,Mark Squall"Listen to advice and accept instruction, and in the end you will be wise." -Proverbs 19:20 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-08-03 : 00:17:12
|
| you just need to ask him to use generate scripts wizard to generate data population scripts for the two tables and send it across as .sql files. then you just need to run it in your db to create the tables as well as the data.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
How to transfer table w/data different computer?