|
|
|
Rank: Guest
Groups: Registered
Joined: 8/10/2009
Posts: 725
|
Hi!
At first: congratulations for this wonderful tool!
I made a script to create the database using th tool, when make the SQL creation of tables, the tool did not put together the primarys keys, and then gave error when creating foreign keys. What could I have done wrong?
Thanks
|
|
|
|
Rank: Administration
Groups: Registered
Joined: 8/10/2009
Posts: 143
|
Please send us your sql script to support [at] sqlbackupandftp.com
|
|
|
|
Rank: Guest
Groups: Registered
Joined: 8/10/2009
Posts: 725
|
Sorry, but I have the free version
How can I send the script ?
thanks !
|
|
|
|
Rank: Guest
Groups: Registered
Joined: 8/10/2009
Posts: 725
|
I did another test with another database and in SQL script, not the party came to PK.
For example:
- This is the script of the original table:
/****** Object: Table [dbo].[tbl_par_municipio] Script Date: 04/30/2010 08:42:26 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[tbl_par_municipio](
[sgestado] [nvarchar](2) NOT NULL,
[cdmunic] [int] NOT NULL,
[nmmunic] [nvarchar](80) NULL,
CONSTRAINT [PK_tbl_par_municipio] PRIMARY KEY CLUSTERED
(
[sgestado] ASC,
[cdmunic] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
-This is the script generated by the backup
--Create table and its columns
CREATE TABLE [dbo].[tbl_par_municipio] (
[sgestado] [nvarchar](2) NOT NULL,
[cdmunic] [int] NOT NULL,
[nmmunic] [nvarchar](80) NULL);
GO
Thanks
|
|
|
|
Rank: Administration
Groups: Registered
Joined: 8/10/2009
Posts: 143
|
You can pack your database to the zip archive and then upload on any free file hosting. Please use a password to protect the archive. Then please send us an email with the URL and the password.
|
|
|
|
Rank: Guest
Groups: Registered
Joined: 8/10/2009
Posts: 725
|
Ok, no problem! link: http://www.megaupload.com/?d=IDDIEX10
zip password: backup thanks
|
|
|
|
Rank: Administration
Groups: Registered
Joined: 8/10/2009
Posts: 143
|
Can you upload the original database?
BTW, what version of program do you use?
|
|
|
|
Rank: Guest
Groups: Registered
Joined: 8/10/2009
Posts: 725
|
ok, http://www.megaupload.com/?d=ARDAP194
password: backup I´m using SQL Server 2008 and SQLBACKUPANDFTP 4.4.1 Thanks
|
|
|
|
Rank: Guest
Groups: Registered
Joined: 8/10/2009
Posts: 725
|
Hi again !
Did you find any kind of problem in my database?
It could be a parameter in my database that is wrong? Or a problem when I create the PK?
Thanks
|
|
|
|
Rank: Administration
Groups: Registered
Joined: 8/10/2009
Posts: 143
|
We've reproduce the issue. I will post message here if we have any progress regarding this issue.
|
|
|
|
Rank: Administration
Groups: Registered
Joined: 8/10/2009
Posts: 143
|
We will include a fix of the issue in the next version of the application. Keep updated
|
|
|
|
Rank: Guest
Groups: Registered
Joined: 8/10/2009
Posts: 725
|
Hi again!
I have installed the version 4.5.1.31357 to test the remote backup and, the creation script created was not generated the primaries keys. This is the last version?
Att,
|
|
|
|
Rank: Administration
Groups: Registered
Joined: 8/10/2009
Posts: 143
|
This fix isn't included in this version
|
|
|
|
Rank: Guest
Groups: Registered
Joined: 8/10/2009
Posts: 725
|
Hello!
I installed the 4.5.2.17440 version but the fix was not yet present. I will await the next update. I'm sorry, but I'm anxious to see this version working. Thanks!
|
|
|
|
Rank: Administration
Groups: Registered
Joined: 8/10/2009
Posts: 143
|
This bug was fixed in version 4.5.3
|
|
|
|
Rank: Guest
Groups: Registered
Joined: 8/10/2009
Posts: 725
|
Good Night!
It worked! Now, I have the script with the Primary keys! Excellent!
One last doubt: There's a way to change the order of the script to create the PK before the FK? Or create the PK along with the tables?
Thank you!
|
|
|
|
Rank: Administration
Groups: Registered
Joined: 8/10/2009
Posts: 143
|
You cannot change this behavior
|
|
|
|
Rank: Guest
Groups: Registered
Joined: 8/10/2009
Posts: 725
|
Yes I can, but if I need to do a restore and create a script to run the sqlcmd command I will need to find and change the script order manually between the various files generated by the tool.
Is There a way to you reverse the order in the tool?
Thanks
|
|
|
|
Rank: Guest
Groups: Registered
Joined: 8/10/2009
Posts: 725
|
Hi again!
The tool is working fine!, But you can not be a way to reverse the order and create the PK before the FK?
Thanks !!!
|
|
|
|
Rank: Newbie
Groups: Registered
Joined: 2/14/2011
Posts: 2
|
Guest wrote:Hi again!
The tool is working fine!, But you can not be a way to reverse the order and create the PK before the FK?
Thanks !!! Hi there! I like this program, but during some testing (restoring databases), we also encoutered some problems with this order... The PK should be restored first and then the FK. Now we need to modify a lot of files to make a succesful restore. Is there a way / update in the future which we reverse this ? Thanks a lot !!! gr, Mark
|
|
|
|
|
