Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Upgrading MSDE 1 DB to MSDE 2000 DB
Just attaching the database should result in an auto-conversion.- PaulBUK
- Post #2
- Forum: Microsoft SQL Server: Programming
-
Transaction and MySQL
I am considering the possibility of using MySQL as a backend for a client server solution. Curently On Windows/Novell we utilise SqlServer 7/2K and SQLBase. On a monthly basis we ship a refreshed entire database in these two formats. The SQLBase one is generated through SQLServers replication... -
Scripting database differences only
You are correct in assuming that the tables involved should not get changed at the customers by anyone except us. Of course, if the customers end is changed by someone else, we might not know about it. With SQLBase its not a problem - embedded users and passwords which cannot be hacked...- PaulBUK
- Post #3
- Forum: Microsoft SQL Server: Programming
-
Scripting database differences only
Internally, my company utilises MS SQl 7.0, but external customers receive a database copy shipped in full periodically in SQLBase, SQLServer (7 or 2000) or (potentially) Oracle. We need to simplify things, and cut costs, so we want to ship the changes only (new/updated/deleted records). PKs...- PaulBUK
- Thread
- Replies: 3
- Forum: Microsoft SQL Server: Programming
