Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

How can I update my SQL Server database schema?

Tags:

sql

sql-server

sql-server-2008

schema

Usually throughout development of a project I will deploy frequently, just to make sure I wont have any problems in production.

Also, throughout development, I find myself changing the database's schema.

How can I easily update the database in production?

I have been dropping the old database and reattaching the new one. Is there a faster way to update the deployment database?

Thanks

EDIT

What are some free tools for this?

like image 265
Ronnie Overby Avatar asked Jul 23 '09 12:07

Ronnie Overby

People also ask

How do I refresh a schema in SQL Server?

To refresh a DSV, double-click the DSV from Solution Explorer in SQL Server Data Tools. This launches the DSV designer. Then click the Refresh Data Source View button in the designer or choose Refresh from the Data Source View menu.

What does it mean to update a schema?

What Does Schema Change Mean? A schema change is an alteration made to a collection of logical structures (or schema objects) in a database.

1 Answers

Try DBSourceTools.
http://dbsourcetools.codeplex.com
Its open source, and will script an entire database
- tables, views, procs and data to disk, and then allow you to re-create that database through a deployment target.
It's specifically designed to help developers get their databases under source code control.

like image 118
blorkfish Avatar answered Sep 27 '22 19:09

blorkfish
Sign in to Comment

Related questions

Migrating Oracle DATE columns to TIMESTAMP with timezone
RBAR vs. Set based programming for SQL
Wrong week number using DATEPART in SQL Server
How to properly name record creation(insertion) datetime field?
One INSERT with UNIONS or multiple INSERTS?
Why is executemany slow in Python MySQLdb?
SQL Query for Grouping the results based on sequence
Delete rows from SQL Server with WHERE statement from different tables
Search in SQL where string starts with X
Can Indices actually decrease SELECT performance?
Select sum and inner join
Oracle SQL Developer 3.1.07 extra spaces between characters using listagg
AND field NOT IN(NULL) returns an empty set [duplicate]
Change TEXT column default from null to '' (empty string)
SQL replace dot with comma
SQLite IntegrityError: UNIQUE constraint failed:
Running count for each 2 rows
Map category parent id self referencing table structure to EF Core entity
conditional on duplicate key update
How to determine position of row in sql result-set?

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!