First make sure myDatabase.mdf is on your local machine unless you already
have remote access enabled.
Open Microsoft SQL Server Management Studio Express. Hint: Run as Administrator on Vista.
Make sure myDatabase is listed as a Database in the Object Explorer,
otherwise attach it.
Right click myDatabase -> Tasks -> Generate Scripts -> [select]
myDatabase -> Select All ... ->Script to new Query Window -> Finish
Next
In the Object Explorer open the remote database where you want the copied
tables and views.
Right click myTargetDatabase ->Tasks -> New Query
Paste in copied script from step 4 from above.
Run
link to download Microsoft SQL Server Management Studio Express
Note: Be careful with constraint options. I also had to copy and paste the data from the source to target data tables in Microsoft SQL Server Management Studio Express like an Excel copy and paste.
2 comments:
Can anyone recommend the well-priced RMM tool for a small IT service company like mine? Does anyone use Kaseya.com or GFI.com? How do they compare to these guys I found recently: N-able N-central service management
? What is your best take in cost vs performance among those three? I need a good advice please... Thanks in advance!
Usually for solve problems with sql server and files too I use other tools. But yesterday no one of theirs couldn't help me. All my sql files were damaged. But luckily for me I found in the Internet - repair database sql. It helped me for seconds and for free as I kept in mind.
Post a Comment