May 26, 2008 at 10:06 pm
I want to transfer a set of tables (with data and relation) from one SQL server to another SQL server. Please let me know the efficient way to do this.
May 26, 2008 at 10:41 pm
Hi
Create a script with all constraints from SERVER A, where you have set of table.. and
create a linked server between these two servers (ie SERVER A and SERVER B).. (see BOL , how to create a linked server)
after that transfer the data (records) to set of table..
Thanks
jaypee.s
May 26, 2008 at 11:22 pm
You can also get the data accross using the Import/Export data tasks
May 27, 2008 at 3:46 am
I am SQL express 2005, so Import and Export option is not available.
May 27, 2008 at 4:23 am
It's very simple, you can download the Microsoft Publishing Wizard from CodePlex site:
May 27, 2008 at 5:48 am
The best way to do that task is to use Import/Export wizard....
Follow these steps.
1) Right Click the database from which you want to transfer the data.
2) Choose Export from the menu.
3) And follow the wizard...
Basit Ali Farooq
MCITP Database Administrator
Microsoft Certified Professional Developer (Web Applications)
Microsoft Certified Database Administrator
Microsoft Certified Systems Engineer
Microsoft Certified Systems Administrator
CIW Security Analyst
Cisco Certified Network Associate
May 28, 2008 at 12:07 am
1. Use "Create Script" to create tables. This will ensure the correct data structure abd its FK, PK and all constraints.
2. Use BCP Out and BCP In to copy data across the tables using the order of tables according to FK constraints.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply