REF: Using MS EXPRESS tools only

Hi UltimaForums,

Thanks for all the responses so far........

Here is a quick question regarding adding NEW tables to an existing deployed Personal (MyPersonal) database hosted by Ultima.

I have a database on your server (MyPersonal) and I want to add 2 new tables to it. What is the best approach to do this... is it...

a) Backup the existing MyPersonal Ultima Database
b) Attach the offline database to SQL Management Studio Express (you advised this in a previous response)
c) Drop any tables that are not relevant leaving just the 2 (new ones) for upload to Ultima
d) Backup the resulting MyPersonal database offline
e) FTP to host area using VWDE
f) Restore the database with the 2 new tables to the existing MyPersonal Database

Am I right in thinking this will add the 2 new tables leaving the existing ones in MyPersonal intact at Ultima or will it wipe all tables in the existing database leaving just the 2 new ones (nightmare scenario)?

Maybe their is a much easier way of doing this using an online SQL tool hosted by Ultima?

What would you advise...?

Thanks in advance for all your help

 

Regards

 

MARK.

---

My Details :
www.mawhitfield.com
www.worsleypark.info
www.mawhitfield.co.uk
www.flickr.com/people/worsleypark/
http://uk.groups.yahoo.com/group/worsleypark/

From what I can tell, your steps will result in a database with ONLY the two new tables in it.  Anytime you restore a database, it is overwritten, not "merged".  Removing step "c:" should result in you having a complete database (old tables and 2 new one's).

However..... 

You could login to your DB via ultimasql.net and just execute a script that creates the new tables:

CREATE table dbo.table1
column1 int,
column2 nvarchar(50)

....etc

Here's some details on SQL 2005 syntax to create a table from a script:  http://msdn2.microsoft.com/en-us/library/ms174979.aspx

Another option is if you have SQL 2005 available locally, you could create it visually using SQL Server Management Studio Express (freely available here).  Once created, right click on the table and then "script table as....CREATE" and it will automatically generate the SQL syntax for creating the table via script.

---

William Eaton, MCSE
iTech Computer Solutions, LLC
www.itechcs.com