Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
hdoddnoble
Starting Member
1 Post |
 Posted - 2005-09-12 : 21:39:38
|
| HiI have created a database on my PC using VS.NET 2005 Beta and SQL Server Express 2005. I now want to place this website on my internet hosting server. For example, my server is SQL5.WEBCONTROLCENTER.COM and my database is called mydatab and i have on my PC a database called origdb. How do i send origdb to the server on the web replacing mydatab?I have Visual Studio 2005 and SQL Express Manager 2005.Many ThanksHarry Dodd-Noble |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2005-09-17 : 18:54:05
|
| Depends what's available.Best would be to basckup the database, ftp the file and restore.Otherwise try dmo as inhttp://www.mindsdoor.net/DMO/SQL-DMOTransfer.html==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2005-09-18 : 02:44:07
|
| RESTORE would be best, as Nigel said. Assuming that is not available I would be inclined to SCRIPT the origdb in Enterprise Manager, create your new, empty, database and then run the script to build the empty tables etc.Then I would use DTS to get the data up there.The Foreign Keys and Triggers will probably get in your way, so I would remove them from the original script [or explicitly DROP them before importing the data] and create them after the data has been imported.Create databaseCreate tables etc. [everything except FKs and Triggers]Import dataCreate FKsCreate TriggersEDIT: I made an assuption that you are familiar with DTS and not with DMO. If you haven't used DTS then going down Nigel's DMO route would be best IMOKristen |
|
|
|
|
|
|
HELP! Database exporting or replacing