Sql Backup And FTP

Welcome Guest Search | Active Topics | Log In | Register
New Topic Post Reply
timestamp columns cause failure trying to load data Options · View
Guest
#1 Posted : Sunday, December 04, 2011 6:18:01 PM Quote
Rank: Guest

Groups:

Joined: 8/10/2009
Posts: 733
Hi,

First off, thanks for making this tool available, its great.

However, I found an issue for our use case.

Most of our tables contain a "timestamp" field. This can not be directly inserted into. However the insert statements attempt to do so. They should be omitting the field or using a DEFAULT so that the server can insert the latest database timestamp. The implication is that you can not exactly duplicate the data, we understand this and need the timestamp in our production server.

Also, can you have an option to make the script work to load the DB into the current DB, not "USE [dbname]" ever where? This would allow us to load older database versions along side the current one.

Thanks,
Ash.
mikeshilov
#2 Posted : Monday, December 05, 2011 1:14:18 PM Quote
Rank: Administration

Groups: Administrators

Joined: 8/12/2009
Posts: 271
Thank you for the feedback, we will consider it.
Quick Reply Show Quick Reply
New Topic Post Reply
Forum Jump  
You can post new topics in this forum.
You can reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You can create polls in this forum.
You can vote in polls in this forum.