Author |
Topic |
tahseenm
Yak Posting Veteran
64 Posts |
Posted - 2006-02-03 : 09:35:01
|
I would like to know the easy way to import and export records from one sql server database to another sql server database and sometimes these database are not in the same sql server. Thanks and appreciate your quick response.moetahsen |
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
tahseenm
Yak Posting Veteran
64 Posts |
Posted - 2006-02-03 : 09:51:09
|
Thanks and I will try to check that. Thanks!moetahsen |
|
|
tahseenm
Yak Posting Veteran
64 Posts |
Posted - 2006-02-03 : 10:04:49
|
I look at the link you send it to me but what I am looking is very simple. I am not moving any database anything like that. All I need to know If I want to transfer certain records from sql Server to another Sql Server table. What I have to do in this situation. Any comments. Thanks!moetahsen |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-02-03 : 10:14:36
|
From Enterprise Manager make use of Import and Export wizard featureMadhivananFailing to plan is Planning to fail |
|
|
Srinika
Master Smack Fu Yak Hacker
1378 Posts |
Posted - 2006-02-03 : 10:16:51
|
Or if u want to happen that at a scheduled time, Or if the records to be selected is known in advance and should need to be done regularly,u can create a DTS package. |
|
|
tahseenm
Yak Posting Veteran
64 Posts |
Posted - 2006-02-03 : 10:20:37
|
Madhivan before I got your reply I was trying to do that using Enterprise MGR wizard and it seems its going to work and here is the steps I am using to do import and export.Just want to let you know guys I was just playing with the SQL Server to import some records from one SQL Server table to another SQL Server table. In order to that I have open SQL Server Enterprise MGR and I select from the menu TOOLS then click on Data Transformation Services then select import and follow the instructions such as Data Source, Server name and the database name, table names, fields etc.(this one is where you are copying the records). Then click next select the Data source again, Server name, database name, table name and fields etc.(this one is where you are going to dump the records). Once you do this I believe you could achieve what I am looking for. I hope this helps and I hope it works. Any suggestion is mostly welcome. Thanks!moetahsen |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2006-02-03 : 17:55:51
|
check out linked server in Books OnLine.----------------------------------'KH' |
|
|
tahseenm
Yak Posting Veteran
64 Posts |
Posted - 2006-02-03 : 19:26:14
|
How you go to books online. Thanks!moetahsen |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2006-02-03 : 20:41:32
|
Books Online is the help file for SQLServer. Look under Start Programs - Microsoft SQL Server----------------------------------'KH' |
|
|
tahseenm
Yak Posting Veteran
64 Posts |
Posted - 2006-02-03 : 23:10:34
|
Thanks and appreciated.moetahsen |
|
|
|