Viewing 15 posts - 61 through 75 (of 106 total)
March 24, 2005 at 2:40 pm
you should look a little closer, it works with your source control
March 23, 2005 at 4:56 pm
I agree with the principal in having all your source code in a source control, however I think you have made it alot more difficult than it needs to be....
March 22, 2005 at 5:55 pm
I agree with the theory of your process but you could save yourself 90-95% of your time if you had a tool made for the job - http://www.dbghost.com
March 22, 2005 at 5:33 pm
you should look at DB Ghost (http://www.dbghost.com) for source code verification using your source control, build, comparison and deployment/synchronization and Apex do a IDE that can connect to your source...
February 28, 2005 at 1:13 am
a unique constraint create an index which is used in searches. A foreign key does not create an index.
regards,
Mark Baekdal
February 17, 2005 at 6:58 am
there's no guareentee that your dependancy information will be correct due to SQL Servers capability of Deferred Name Resolution and Compilation. Text searches will can also be inaccurate.
Building from source...
February 17, 2005 at 2:56 am
You may want to check out database change management software. DB Ghost (http://www.dbghost.com) will help you create a perfect release by identifying any problems in your source code through compilation.
February 17, 2005 at 12:14 am
When I need to delete columns I use the scripts of the database to do this - removing the column definitions and then testing a database build using DB Ghost...
February 17, 2005 at 12:10 am
The problems you talk about I would say have to do with accurate database change management. Developing via source control and deploying via source control gives you control over the...
February 4, 2005 at 1:26 am
You can get a tool or a stored procedure to do this. As part of our main product DB Ghost we give away a data and schema scripter which will create...
February 2, 2005 at 11:33 pm
Heard of DB Ghost?
January 20, 2005 at 12:29 am
In Query Analyzer press F8 for the object browser.
Drill down into the database of choice until you find the table you want to work with.
Right click, you'll be able to...
January 20, 2005 at 12:19 am
or you could use this:
select convert(varchar(12),getdate()) + right(convert(varchar,getdate(),126),len(convert(varchar,getdate(),126))-charindex('T',convert(varchar,getdate(),126)))
result = Jan 19 2005 08:48:19.397
depending on your preferencing for displaying the date to your users.
regards,
Mark Baekdal
January 19, 2005 at 2:03 am
Viewing 15 posts - 61 through 75 (of 106 total)