| Author |
Topic |
|
Jayeeta Mitra
Starting Member
11 Posts |
 Posted - 2008-03-05 : 06:28:44
|
| I had created a database of my own having 6 tables.I want this database to transfer it one of my friends who will link it with VB.Net platform to run a software.Pls help in this context. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-03-05 : 06:33:03
|
| Try using SSIS Transfer db objects tasks to transfer this db to his local server. |
 |
|
|
Jayeeta Mitra
Starting Member
11 Posts |
Posted - 2008-03-05 : 06:34:35
|
| Where I can find that? |
|
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2008-03-05 : 06:46:24
|
| Are you using SQL Server 2000 or 2005?Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
|
|
|
Jayeeta Mitra
Starting Member
11 Posts |
Posted - 2008-03-05 : 07:43:05
|
| SQL Server 2000 |
|
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2008-03-05 : 07:52:31
|
| Then you can use Data Transformation Services(DTS) instead of SSIS. You can find it in Microsoft SQL Server program group under start menu.Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2008-03-05 : 08:28:26
|
| or do backup and restore in your friend's systemMadhivananFailing to plan is Planning to fail |
|
|
|
Jayeeta Mitra
Starting Member
11 Posts |
Posted - 2008-03-05 : 09:30:59
|
| My friend lives far away from me.He has done the coding of the project in VB.Net and I have made the database.Now I want the database made in my machine is transferred to his machine so that he can make the connection with .Net.I can't getthe method you are suggesting.Pls help. |
|
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2008-03-05 : 09:46:54
|
| Is SQL Server installed on your friend's system?Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
|
|
|
Jayeeta Mitra
Starting Member
11 Posts |
Posted - 2008-03-05 : 09:47:58
|
| Yes,SQL Server is installed in his system |
|
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2008-03-05 : 09:50:36
|
| Then do as Madhi said. Take a backup of your database on some removable media and restore it on your friend's system.Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
|
|
|
|
Database transfer