[LiamM]

Hello guys,

Well as a lot of developers have, I have a test server, merely to just script things in, test them out ensure they are fully working and then push them out to the live server (just to prevent the live release being buggy).

However, I've came across a question that came into my mind after making some additions to a table within the database.
Is there a way to export all the columns and import the columns without the data into the live versions database (Test and Live use separate databases).

For example, I add 2 new columns, then make the script use those two columns, as opposed to me going and manually adding the new columns to the live servers database, is there a way to export them and import them so it does it for me?
I tried exporting columns without data and I got 'column already exists' for half of the tables because it's trying to import the whole table and not just the new columns, this can be a pain when adding like 15 new columns...

Hope I made sense there lol

[Vince]

No. Any changes made on the test database must be replicated exactly on the live database. So whenever you do something, save the SQL statements.

[LiamM]

Quote:

Originally Posted by Vince No. Any changes made on the test database must be replicated exactly on the live database. So whenever you do something, save the SQL statements.

Prompt and straight to it, thanks for letting me know, Vince! Glad to get a fast and efficient response from you!