Jodi_the_g
Member
Registered: 7th Aug 01
Location: Washington D.C
User status: Offline
|
I have one on my server I want to put it locally on my workstation for quicker testing.
How do i get a copy of the sql so I can build it on my local workstation.
I tried copying the file but it will not let me as it is use by another program.
|
Leighton
Member
Registered: 21st Feb 01
Location: Liverpool
User status: Offline
|
Try this:
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q314546
|
Dan Lewis
Member
Registered: 31st Jan 05
Location: Leicestershire
User status: Offline
|
you have to take the database offline first.
|
Brett
Premium Member
Registered: 16th Dec 02
Location: Manchester
User status: Offline
|
 You soooo started doing this SQL without knowing wtf you're talking about.
|
Sam
Moderator
Premium Member
Registered: 24th Dec 99
Location: West Midlands
User status: Offline
|
Brett
I don't know what the deal is with MSSQL but with MySQL all I ever do is export all the tables to a .SQL file and import into <wherever>, is this not the case with MSSQL then? 
|
Jodi_the_g
Member
Registered: 7th Aug 01
Location: Washington D.C
User status: Offline
|
quote:
Originally posted by Sam
Brett
I don't know what the deal is with MSSQL but with MySQL all I ever do is export all the tables to a .SQL file and import into <wherever>, is this not the case with MSSQL then?
I not worked with it in ages, and could not find the function to do this and was in a bit of a rush.
|
James
Member
Registered: 1st Jun 02
Location: Surrey
User status: Offline
|
SQL Server 2000 or 2005?
Is it a big DB?
|
Ian
Site Administrator
Registered: 28th Aug 99
Location: Liverpool
User status: Online
|
mysqldump if it's a proper database.
Not sure about the Microsoft way. Probably takes longer and is harder.
|
Jodi_the_g
Member
Registered: 7th Aug 01
Location: Washington D.C
User status: Offline
|
quote:
Originally posted by James
SQL Server 2000 or 2005?
Is it a big DB?
2005 only worked with 2000 before an a while ago so its just a case of finding everything.
|
James
Member
Registered: 1st Jun 02
Location: Surrey
User status: Offline
|
Open up SQL Server Management Studio.
Expand databases, right click on DB name, Tasks > Generate Scripts.
Follow the wizard to generate the scripts for all the DB objects.
Obviously this won't include data. If you need data you will need to backup the data and then restore it locally.
This can be done by right clicking the DB and selecting Tasks > Backup
|
Jodi_the_g
Member
Registered: 7th Aug 01
Location: Washington D.C
User status: Offline
|
Thanks James
|
