Skip to content
This repository has been archived by the owner on May 7, 2024. It is now read-only.

dump database exclude-type user will lose the full text index #106

Closed
heyprogrammer opened this issue Jun 27, 2017 · 3 comments
Closed

dump database exclude-type user will lose the full text index #106

heyprogrammer opened this issue Jun 27, 2017 · 3 comments

Comments

@heyprogrammer
Copy link

heyprogrammer commented Jun 27, 2017

@MrMeemus Hello MrMeenus,I have tried the latest version a1.0.0a14 and I find a bug.
when I dump database not include the create database and create user statement, the table-level full-text index will be removed.If I did't remove the create database and create user statement,full-text index will be successfully dumped out。
My executive commands are

mssql-scripter -S localhost -d test -U user1 > test.sql
mssql-scripter -S localhost -d test -U user1 --exclude-types User > test.sql

The second command is missing as follows

CREATE FULLTEXT INDEX ON [dbo].[customer](
[name] LANGUAGE 'Simplified Chinese')
KEY INDEX [PK_customer]ON ([CustomerSearch], FILEGROUP [PRIMARY])
WITH (CHANGE_TRACKING = AUTO, STOPLIST = SYSTEM)

Thank you for your answer.

@heyprogrammer heyprogrammer changed the title How to dump database not include the create database and create user statement? dump database exclude-type user will lose the full text index Jun 28, 2017
@heyprogrammer
Copy link
Author

In addition, even if I use --schema-and-data, if exclude-types User, data will not dump successfully.

@MrMeemus
Copy link
Contributor

@heyprogrammer , thanks so much for your feedback! I have found the issue, seems like we lose flags when using any include/exclude filters. We shall have a new release by the end of today :)

@MrMeemus
Copy link
Contributor

fixed in #108.

Please feel free to upgrade to 1.0.0a15 :)

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants