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 |
|
neerav.saini
Starting Member
9 Posts |
 Posted - 2009-06-24 : 06:43:20
|
| hi all,In my database i want to create new *.mdf file and i want to transfer selected tables frmo old mdf to new one.Is this possible?If yes how to create and how to move data from old mdf to new mdf?Thanks,Neerav |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-06-24 : 06:44:26
|
You can use the Copy Database Wizard.
E 12°55'05.63"N 56°04'39.26" |
 |
|
|
ajay_uiet
Starting Member
9 Posts |
Posted - 2009-06-24 : 06:49:36
|
| You can first create a file group in the old database.Move the file in that file group.Then add this file group to the new MDF |
|
|
|
neerav.saini
Starting Member
9 Posts |
Posted - 2009-06-24 : 07:05:04
|
| hi ajay,thanks for help till now.Please explain with example?likwise database D1 is existing and test.mdf already there.I want to create NEWTEST.mdf in D1 and transfer data or table from test.mdf to newtest.mdfWaiting for replyThanks,Neerav |
|
|
|
ajay_uiet
Starting Member
9 Posts |
Posted - 2009-06-25 : 00:59:36
|
| Please refer to the linkhttp://www.mssqltips.com/tip.asp?tip=1112 |
|
|
|
|
|
|
.mdf question