March 17, 2010 at 3:51 pm
Ok..
Ms SQL 2005 database
I have a empty database at my hoster site. Its has nothing in it period.
The admin's of the hosting site (asp.net 2.0) said send them a .bak file.
Well I know how to generate a .sql file of all the tables and proceedure in my database from : selected database >tasks>generate scripts.
Q1: So how do I generate a .bak file to populate my empty database at my hosting site, with all tables, procs, etc? Please explain process. I thought .bak was for back up situations.
Q2: The hoster admins only want .bak files to do tweaks to my database, so how does a .bak file acheive this for a just adding a table or a store proc only ?
Q3: Some tables had data in them, is there a way to generate a INSERT script for each data row, or do I have to do an EXPORT from my localhost and an import at my hosting site?
March 17, 2010 at 4:36 pm
they could restore the database as a different name then transfer the data required to your empty database locally, perhaps that is what they plan to do.
right click on your database, select tasks then backups or check out backup syntax in BOL.
---------------------------------------------------------------------
March 17, 2010 at 4:42 pm
SSCrazy,
Yes I have now found how to run a .bak
BUt I had three questions, could you answer the three for me, thanks
March 17, 2010 at 5:31 pm
I thought I had.
If they have the database at your hosting site they would be able to do the data transfer locally which would be much quicker. As I said I guess thats why they asked for a backup file.
I wouldn't generate insert commands for every data row, thats a very slow way to transfer data. Once the database is local you can use SSIS, export/import wizard or select into or insert..(select from) to transfer the data.
---------------------------------------------------------------------
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply