Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
HomeAnnouncementsFree MagazinesWhite PapersSubmit Content
Discussion GroupsASP.NETWindows FormsLanguages.NET FrameworkVisual Studio.NET
Articles.NET FrameworkASP.NETToolsWindows Forms
.NET DirectoryOpen Source ProjectsUser GroupsWeb Resources
Related Topics
Visual Basic 6SQL ServerMS AccessOther DB ProductsMS Server ProductsMore Topics ...

.NET Forum / .NET Framework / ADO.NET / February 2008

Tip: Looking for answers? Try searching our database.

How import data from SQL Server?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Bobby Edward - 22 Feb 2008 04:04 GMT
What's the best way to import all the tables (w/data) from an SQL Server
database (in production) to my SQL Express database (on my local dev
machine)?
RobinS - 23 Feb 2008 01:52 GMT
I don't know if this will work, but you can try detaching the database from
SQLServer (production) and making a copy of the files, then reattaching it.
Then copy over the copy and attach it to your local version. This works
going from SQLServer to SQLServer; not sure how you attach files in Express.

If you can't detach it in production, you could always try copying it. This
has worked for me in the past when there are no locks on the db.

RobinS.
---------------------------
> What's the best way to import all the tables (w/data) from an SQL Server
> database (in production) to my SQL Express database (on my local dev
> machine)?
Rad [Visual C# MVP] - 28 Feb 2008 21:36 GMT
> What's the best way to import all the tables (w/data) from an SQL Server
> database (in production) to my SQL Express database (on my local dev
> machine)?

Short of copying the file (easiest I would think) you have a couple of
options
- Script it on the production sever and run it on the dev
- Create a DTS (SQL 2000 and older) or a SSIS package (SQL 2005+) to do
this automatically
- Some companies make tools that allow you to synchronize database
structures and scemas. Check out a company called SSW that makes one. And
RedGate too. SQL Compare I think.

Signature

http://www.thinkersroom.com/bytes


Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...

Oracle MagazineNetwork ComputingComputer WorldBio-IT WorldeWeekInformation WeekInfosecurity
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.