SQL tables transfer from DEV local to company server

mattkorguk

Registered User.
Local time
Today, 14:37
Joined
Jun 26, 2007
Messages
301
Hi,
I've been developing an SQL back-end to one of our Access databases, and it looks like it's ready to be installed on site.
It's currently running on a local SQL Express 2005 install, and all is well, I was just wondering what's required to transfer/ move these tables (which will be empty when moved) from the DEV to the companies server?
Can I just move the .mdf file? Somehow I don't think it'll be that straightforward. :rolleyes:

Thanks,
Matt
 
Hi there

If it's only the database structure you want to move with no data then I would recommend scripting the entire database.

Right click on the database in management studio express and select 'generate scripts' select 'script database' and make sure the script all objects check box is ticked.

Copy the code into text file and move the text file over to the production server and run the code.
 
Wow - Now that sounds just the ticket! :D
We're visiting either tomorrow or Friday, I'll update when completed.

Thank you very much for that.
Matt
 

Users who are viewing this thread

Back
Top Bottom