Overclock.net › Forums › Specialty Builds › Servers › SQL Server 2008 R2: Importing SQL
New Posts  All Forums:Forum Nav:

SQL Server 2008 R2: Importing SQL

post #1 of 3
6/1/12 at 8:45am
Thread Starter 
Couldn't think of anywhere else to put this. I'm building a mobile product for a customer, which is driven by an existing database under SQL Server 2008 R2. Due to data sensitivity concerns, the customer could only export the schemas and stored procedures, as .sql files.

I;ve replicated their setup - Windows Server 2008 R2, SQL Server 2008 R2 - but now I need a way of importing those .sql files back into SQL Server 2008.

Has anyone done this before? Is it even possible? Replies will be much appreciated. smile.gif
Mythica
(14 items)
  		  
CPUMotherboardGraphicsRAM
Intel i3 530 Gigabyte GA-H55M-D2H Palit nVidia GT430 Corsair Dominator 4GB TW3X4G1333C9A 
Hard DriveHard DriveOSMonitor
Hitachi Deskstar 7K500 Samsung HD204UI Linux Mint 13 HP L1800 
KeyboardPowerCaseMouse
Trust EasyScroll Silverline Corsair HX520 Lian-Li PC-A04B Logitech Trackman Wheel 
View all
  hide details  
Reply
Mythica
(14 items)
  		  
CPUMotherboardGraphicsRAM
Intel i3 530 Gigabyte GA-H55M-D2H Palit nVidia GT430 Corsair Dominator 4GB TW3X4G1333C9A 
Hard DriveHard DriveOSMonitor
Hitachi Deskstar 7K500 Samsung HD204UI Linux Mint 13 HP L1800 
KeyboardPowerCaseMouse
Trust EasyScroll Silverline Corsair HX520 Lian-Li PC-A04B Logitech Trackman Wheel 
View all
  hide details  
Reply
post #2 of 3
6/1/12 at 1:54pm
I'm not on my work machine, but I think the steps to do this is
  1. Install Sql Server Management Studio (there's a command line way, but I don't know it
  2. Connect to Sql Server
  3. Select the new database
  4. run the .sql in a new Query Window

That should make all the tables, stored procedures, and schema

But you'll have to do the permissions over.

EDIT : can use Import/Export Wizard? : http://msdn.microsoft.com/en-us/library/ms140052.aspx
Main PC
(13 items)
  		  
CPUMotherboardGraphicsRAM
i5 2500k Asus Maximus IV Gene-Z MSI 6950 2gb Unlocked Ref GSkill Ripjaws X 8GB CL8 
Hard DriveOSMonitorKeyboard
Crucial M4 128GB Windows 7 Ult Samsung 24" ToC Das Professional Silent 
PowerCaseMouse
Seasonic X750 Corsair 650d Logitech G700 
View all
  hide details  
Reply
Main PC
(13 items)
  		  
CPUMotherboardGraphicsRAM
i5 2500k Asus Maximus IV Gene-Z MSI 6950 2gb Unlocked Ref GSkill Ripjaws X 8GB CL8 
Hard DriveOSMonitorKeyboard
Crucial M4 128GB Windows 7 Ult Samsung 24" ToC Das Professional Silent 
PowerCaseMouse
Seasonic X750 Corsair 650d Logitech G700 
View all
  hide details  
Reply
post #3 of 3
6/1/12 at 2:35pm
Thread Starter 
Hey, many thanks for that. In fact I tried that earlier and it didn't look as if it had worked, then I realised that the tree in the left-hand pane doesn't auto-refresh. A manual refresh shows the new tables after they are added. smile.gif
Mythica
(14 items)
  		  
CPUMotherboardGraphicsRAM
Intel i3 530 Gigabyte GA-H55M-D2H Palit nVidia GT430 Corsair Dominator 4GB TW3X4G1333C9A 
Hard DriveHard DriveOSMonitor
Hitachi Deskstar 7K500 Samsung HD204UI Linux Mint 13 HP L1800 
KeyboardPowerCaseMouse
Trust EasyScroll Silverline Corsair HX520 Lian-Li PC-A04B Logitech Trackman Wheel 
View all
  hide details  
Reply
Mythica
(14 items)
  		  
CPUMotherboardGraphicsRAM
Intel i3 530 Gigabyte GA-H55M-D2H Palit nVidia GT430 Corsair Dominator 4GB TW3X4G1333C9A 
Hard DriveHard DriveOSMonitor
Hitachi Deskstar 7K500 Samsung HD204UI Linux Mint 13 HP L1800 
KeyboardPowerCaseMouse
Trust EasyScroll Silverline Corsair HX520 Lian-Li PC-A04B Logitech Trackman Wheel 
View all
  hide details  
Reply
New Posts  All Forums:Forum Nav:
  Return Home
  Back to Forum: Servers
Overclock.net › Forums › Specialty Builds › Servers › SQL Server 2008 R2: Importing SQL