Africasgateway.com

Other => Geek Section => Topic started by: RearrangedReality on August 28, 2009, 04:15:08 PM

Title: SQL DB Copy from server
Post by: RearrangedReality on August 28, 2009, 04:15:08 PM: anybody here know how to replicate a SQL DB from a server. wanna take work home but want to have a copy of the DB from our server to my machine. help anyone?
Title: Re: SQL DB Copy from server
Post by: The KWEDZA HOD on August 28, 2009, 04:20:03 PM: are you on php? be fast im almost out
Title: Re: SQL DB Copy from server
Post by: MrC The Rap God Almighty on August 28, 2009, 04:24:47 PM: I think Enterprise Manager gives you an option under one of it's menu's to export and import the DB.
Title: Re: SQL DB Copy from server
Post by: RearrangedReality on August 28, 2009, 04:30:56 PM: nah im accessing from Visual Studio. I dont have enterprise manager.
Title: Re: SQL DB Copy from server
Post by: ProVerb on August 28, 2009, 04:33:18 PM: eish read up cats!
Title: Re: SQL DB Copy from server
Post by: RearrangedReality on August 28, 2009, 04:34:47 PM: eish he's gone.

Thanks Mrc, Im out, I'll recreate it manually cause im not trying to be in this building tomorrow.
Title: Re: SQL DB Copy from server
Post by: RearrangedReality on August 28, 2009, 04:37:07 PM: Quote from: ProVerb on August 28, 2009, 04:33:18 PM
eish read up cats!

lol
Title: Re: SQL DB Copy from server
Post by: MrC The Rap God Almighty on August 28, 2009, 04:39:06 PM: I think there's a command line utility called "bcp.exe", run it and look @ it's usage, parameters,etc. But i think it comes with the SQL Server binaries, so you need to have installed some SQL Server software on your machine.

Haven't worked with databases on Windows for a while now.
Title: Re: SQL DB Copy from server
Post by: ProVerb on August 28, 2009, 04:44:43 PM: Quote from: MrC The Rap God Almighty on August 28, 2009, 04:39:06 PM
I think there's a command line utility called "bcp.exe", run it and look @ it's usage, parameters,etc. But i think it comes with the SQL Server binaries, so you need to have installed some SQL Server software on your machine.

Haven't worked with databases on Windows for a while now.

Now you just Showin off!
Title: Re: SQL DB Copy from server
Post by: RearrangedReality on August 28, 2009, 04:56:23 PM: Quote from: MrC The Rap God Almighty on August 28, 2009, 04:39:06 PM
I think there's a command line utility called "bcp.exe", run it and look @ it's usage, parameters,etc. But i think it comes with the SQL Server binaries, so you need to have installed some SQL Server software on your machine.

Haven't worked with databases on Windows for a while now.

Thanks man. I will recreate it. I need some sleep.
ps: the command prompt appears and disappears within a second after running bcp.exe. will play around with that some other time.
Title: Re: SQL DB Copy from server
Post by: The KWEDZA HOD on August 28, 2009, 10:18:02 PM: Comand line, usefull when ur network admin has a big head, you can teach him a thing or two from there....

*hint* *hint*