Posts
Sort by recent activity
Database creation script
Hi:
Is it possible to create and maintain a sql script that faithfully recreates a database schema with SQL Compare version 6?
I have a script that creates a new database, from scratch, and replica...
SQL Backup Lite - Password protection
Hi:
I know that SQL Backup Lite does not encrypt data, but can I password protect a backed up file?
TIA,
Martin.
SQL Backup Lite - SQL Server 2005 Express
Hi:
As SQL Server 2005 Express does not have SQL Agent included, can the SQL Backup Lite still do scheduled backups?
TIA,
Martin.
Product registration and activation
Hi:
I have installed SQLBackup Pro and activated the product on one computer. I have then installed, remotely, the server components on 3 other machines.
When I select the 2 remote servers in the l...
Restore on a different server
Hi:
I have done a (test) full backup on my local server, and want to restore the database to a different server, that does not contain this database yet.
I select the backup set from the original s...
Comparing various snapshots
Hi:
I'm new to AntsProfiler so please excuse my very basic question.
If I run the memory profiler and after startup take a snapshot (lets call it snapshot1), run some processes and take a second sn...
Foreign Key actions (on update - on delete)
Hi:
I am comparing 2 databases that have different actions specified under a Foreign Key actions, and these are not being picked up by SQL Compare.
This *may* be a SQLServer 2005 database issue as ...
MSSQL 2005 support
Hi:
I am working on a project that will not be released before the end of this year, but when it is released it will be for MSSQL 2005, so we want to start doing our development with Visual Studio ...
Column rename - can I override this?
Hi:
I have a database I'm updating that has an old column name of 'Banco_id' and this field is no longer needed, but a new column 'Banco' will be introduced, both fileds are integers.
When I run SQ...
Newbie question - WITH NOCHECK
When comparing two supposedly iqual databases I get several foreign key differences stating that the 'WITH NOCHECK' values differ.
When I use Enterprise Manager I can't see any differences when I i...