Best practice for uploading MS SQL database to host
My host will only allow me to upload ms sql 2005/2008 changes via the "Import and Export Data" utility in 2008 r2. Restoring dumps has a $5 charge, something I'd rather avoid. While I have had success this way (firstly by wiping all tables out prior to upload, btw) I have the error noted here at the old forum: http://forum.umbraco.org/yaf_postst8661_Cannot-create-new-nodes-or-publish.aspx which tells me that the IED utility doesn't do a complete import.
What should I consider, outside of switching hosts?
There are so many more vagueries with ms sql versus mysql; for the better, no doubt, but it complicates these "little" tasks. I just found out that I can simply do a "restore" albeit with tech's help, for gratis, via ms sql studio manager. They don't publish their ms sql server connections, so the script wizard is no help. So, I remain curious, but can safely move on to other fronts, like wrapping this project up.
i had a similar problem with one of my client's own hosts. i used the sql export wizard to create a script from my local database which i could then run via sql management studio against a fresh database on the destination server.
The SQL Publishing wizard is a part of SQL server 2008 and is located here:
Program Files (x86)\Microsoft SQL Server\90\Tools\Publishing\1.4\SqlPubWiz.exe
I know you posted this ages ago and it's probably sorted now, but if someone is searching for similar then they will hopefully come across this answer!
tentonipete : I was all excited to check it out. Turns out that my version, 2008 sqlexpress doesn't support this feature. It's times like that that I dearly miss using MySQL or MariaDB.
there may be some other options in express for scripting the database. The utility I mentioned earlier gives you a nice interface for generating a script that contains schema and data. I'm pretty sure there will be a way in sqlexpress to do this too.
Best practice for uploading MS SQL database to host
My host will only allow me to upload ms sql 2005/2008 changes via the "Import and Export Data" utility in 2008 r2. Restoring dumps has a $5 charge, something I'd rather avoid. While I have had success this way (firstly by wiping all tables out prior to upload, btw) I have the error noted here at the old forum: http://forum.umbraco.org/yaf_postst8661_Cannot-create-new-nodes-or-publish.aspx which tells me that the IED utility doesn't do a complete import.
What should I consider, outside of switching hosts?
Thanks!
There are so many more vagueries with ms sql versus mysql; for the better, no doubt, but it complicates these "little" tasks. I just found out that I can simply do a "restore" albeit with tech's help, for gratis, via ms sql studio manager. They don't publish their ms sql server connections, so the script wizard is no help. So, I remain curious, but can safely move on to other fronts, like wrapping this project up.
i had a similar problem with one of my client's own hosts. i used the sql export wizard to create a script from my local database which i could then run via sql management studio against a fresh database on the destination server.
The SQL Publishing wizard is a part of SQL server 2008 and is located here:
Program Files (x86)\Microsoft SQL Server\90\Tools\Publishing\1.4\SqlPubWiz.exe
I know you posted this ages ago and it's probably sorted now, but if someone is searching for similar then they will hopefully come across this answer!
tentonipete: thanks for the suggestion. I'll try it tomorrow.
cool. make sure you do it on an empty database on the destination server.
tentonipete : I was all excited to check it out. Turns out that my version, 2008 sqlexpress doesn't support this feature. It's times like that that I dearly miss using MySQL or MariaDB.
Thanks,
Kyle
there may be some other options in express for scripting the database. The utility I mentioned earlier gives you a nice interface for generating a script that contains schema and data. I'm pretty sure there will be a way in sqlexpress to do this too.
Sigh. I did a second check. I used WebPI to install a MS SQL Tools package which dumped more stuff on my machine, but no sqlpubwiz.exe to be found.
this answer might help. just remember to include the data like one of the comments says
http://stackoverflow.com/questions/1162339/script-entire-database-sql-server
is working on a reply...