How import data from SQL Server?

  • Thread starter Thread starter Bobby Edward
  • Start date Start date
B

Bobby Edward

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)?
 
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)?

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.
 
Back
Top