Search
Search titles only
By:
Search titles only
By:
Forums
New posts
Search forums
What's new
New posts
Latest activity
Feedback
View Statistics
Members
Current visitors
Buy Sell Trade
WTB
Log in
Register
Search
Search titles only
By:
Search titles only
By:
New posts
Search forums
Menu
Install the app
Install
Reply to thread
Forums
Technology
Programming
How To transfer tables made in sql server 2008 from one machine to another machine!!
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Message
<blockquote data-quote="Sei" data-source="post: 1204368" data-attributes="member: 5839"><p><strong>Re: How To transfer tables made in sql server 2008 from one machine to another machin</strong></p><p></p><p>Firstly, you cannot simply copy the database files(mdf and ldf) without stopping the SQL server service. </p><p></p><p>For you to be able to use it on your own PC, there are 2 ways. Either you extract the tables to an excel/CSV file or you transfer the database(mdf) and log(ldf) files to your PC and attach them to SQL server. </p><p></p><p>If you want to do the first, then you can do it either via SSIS or via the query mode -</p><p></p><p>SSIS - <a href="http://msdn.microsoft.com/en-us/library/ms140052.aspx" target="_blank">How to: Run the SQL Server Import and Export Wizard</a></p><p></p><p>Query - <a href="http://dayananthan.wordpress.com/2008/01/08/export-data-from-sql-server-to-excel-without-using-ssis-or-dts/" target="_blank">Export data from SQL Server to Excel without using SSIS or DTS « Dayananthan’s Weblog</a></p><p></p><p>If you want to copy the database (data file + log file) to your own PC to run it in by attaching it in SQL server (you cannot open mdf and ldf in notepad/wordpad if that's what you were thinking):</p><p></p><p><a href="http://forum.admins.ir/showthread.php?p=53431" target="_blank">Moving a Database from SQL Server 2005 to SQL Server 2008 in Three Steps - PersianAdmins</a></p><p></p><p><a href="http://msdn.microsoft.com/en-us/library/ms191491.aspx" target="_blank">How to: Detach a Database (SQL Server Management Studio)</a></p><p></p><p>Do you have SQL server installed on your local pc??</p></blockquote><p></p>
[QUOTE="Sei, post: 1204368, member: 5839"] [b]Re: How To transfer tables made in sql server 2008 from one machine to another machin[/b] Firstly, you cannot simply copy the database files(mdf and ldf) without stopping the SQL server service. For you to be able to use it on your own PC, there are 2 ways. Either you extract the tables to an excel/CSV file or you transfer the database(mdf) and log(ldf) files to your PC and attach them to SQL server. If you want to do the first, then you can do it either via SSIS or via the query mode - SSIS - [url=http://msdn.microsoft.com/en-us/library/ms140052.aspx]How to: Run the SQL Server Import and Export Wizard[/url] Query - [url=http://dayananthan.wordpress.com/2008/01/08/export-data-from-sql-server-to-excel-without-using-ssis-or-dts/]Export data from SQL Server to Excel without using SSIS or DTS « Dayananthan’s Weblog[/url] If you want to copy the database (data file + log file) to your own PC to run it in by attaching it in SQL server (you cannot open mdf and ldf in notepad/wordpad if that's what you were thinking): [url=http://forum.admins.ir/showthread.php?p=53431]Moving a Database from SQL Server 2005 to SQL Server 2008 in Three Steps - PersianAdmins[/url] [url=http://msdn.microsoft.com/en-us/library/ms191491.aspx]How to: Detach a Database (SQL Server Management Studio)[/url] Do you have SQL server installed on your local pc?? [/QUOTE]
Insert quotes…
Verification
Post reply
Forums
Technology
Programming
How To transfer tables made in sql server 2008 from one machine to another machine!!
Top
Bottom